Hi team,
I am looking to have a column of hyperlinks (in say Row B), and have Column A be the cells that have the firendly name, which will be pulled from a list on a different sheet.
EG:
Cell A1=Data validation value. of "In Progress" and "Done" (The text here is not important, I essentially want the text to be a hyperlink to the same URL regardless of what I select)
Cell B1 = URL of a Google Doc.
I would like Cell A1 to always link to the Google Doc URL in Cell B1, regardless if the person selects "In Progress' or "Done". Is there a way to have a cell always be a hyperlink from a value on another cell, regardless of the text in that cell?
NOTE: The Hyperlinks will likely be on a different sheet, I am just using this as an example.
I am looking to have a column of hyperlinks (in say Row B), and have Column A be the cells that have the firendly name, which will be pulled from a list on a different sheet.
EG:
Cell A1=Data validation value. of "In Progress" and "Done" (The text here is not important, I essentially want the text to be a hyperlink to the same URL regardless of what I select)
Cell B1 = URL of a Google Doc.
I would like Cell A1 to always link to the Google Doc URL in Cell B1, regardless if the person selects "In Progress' or "Done". Is there a way to have a cell always be a hyperlink from a value on another cell, regardless of the text in that cell?
NOTE: The Hyperlinks will likely be on a different sheet, I am just using this as an example.
