I have a form that allows someone to take an image which is displayed on the responce page as an URL link.
There will be a report page which will populate based on the date entered using vlookup and index match formulas.
I am looking for a way to display the image on the report page rather than just a URL link.
I found one formula that works, but you need to cut the image name out of the original link and apply it to the image formula in order to see the image.
The report should be dynamic and have all the fields populate without the user cutting and pasting.
Any Thoughts?
https://docs.google.com/spreadsheets...#gid=516169362
Bookmarks