Copy Sheet Name Hyperlinks to Another Sheet

Scott Peters
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.
    Genevieve P. Employee Admin

    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", "" ...

    Keep in mind this would be unable to find a match if the sheet names are updated down the line.