I have images on my google drive populated from Appsheet.
I generate daily reports on excel.
I want to get a link of the image (public link kind of thing) to be present in a column of the image. User clicks the link, image should be displayed.
I browsed through and shared the google drive folder to be available publicly. How can use this link in a excel file. Meaning, I have the public folder link now and also the file name is stored in a column, Can I merge these using Concatenate etc., to display the link in the excel (public URL)?