Google Sheets AppScript - Add custom link to retrieved value.

[antonyx]

On my 'Orders' worksheet, I am using some script to populate the Item column based on the chosen Style value.

EXAMPLE GOOGLE SHEET

Double click any empty cell in the Style column choose CODE 3 - the Item column will automatically populate with ITEM 3. It retrieves this data from the 'Styles' worksheet.

I am also storing a single URL for each item. When the script runs and populates the Item column, I would like that value to be clickable, and point to the URL stored in the 'Styles' worksheet.

So in the above example, everything would work the same - but Item 3, if clicked, would open www.item3.com

I'm wondering if this is at all possible.

Thank you in advance for any help.

[janmorris]

Hi antonyx,

on the Orders sheet, try changing the formula in cell K1 to the following:

Please Login or Register  to view this content.

Screen Shot 2022-04-23 at 12.40.58 am.png

[antonyx]

That's awesome, works perfectly and the formula makes perfect sense.

Thank you so much.