Copy Sheet Name Hyperlinks to Another Sheet

Scott Peters

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

Genevieve P.

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