Copy Sheet Name Hyperlinks to Another Sheet
Hello Community - Has anyone found a way to copy the contents of the SHEET NAME column in a report to another Smartsheet? I was able to do it with Data Mesh but it just delivers the text content, not the hyperlink
Answers
-
Hey @Scott Peters
I believe this may only possible using the Smartsheet API or Bridge. You could use the Get Report API call with the parameter include = sourceSheets to get all the source sheet URLs, then insert those URLs into a cell in a sheet.
Another option would be to use DataMesh as you're doing, then have a Nested IF formula read the sheet name and return a URL based on that value.
=IF([Sheet Name]@row = "Sheet 1", "https://app.smartsheet.com/sheets/xxx" ...
Keep in mind this would be unable to find a match if the sheet names are updated down the line.
Cheers,
Genevieve