Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Hyperlink to a row/cell in the same sheet?


I am working on an "issues log" in smartsheet and I want the ability to respond to duplicate issue by marking it as duplicate (checkbox) and the next column (Duplicate Of) place the auto numbered row number of the duplicate issue.  I would then like to put in the next column (Duplicate Link) a hyperlink to jump to that row. Is there any function that allows me to do this?  Hyperlink to other smartheet and cell linking don't seem to be the right option. 


  • JohnHinkle
    JohnHinkle ✭✭✭✭✭✭

    There isn’t a way to create a link that will jump to another row. You could add the row number then use the keyboard shortcut CTRL + G to go to the row.

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭


    I have a workaround that might help. 

    1. Create a Table of content section in the sheet (at the top)
    2. Create a new column (Count)
    3. Use the following formula in the Count column.

      =1 + 0 (Copy down the whole sheet)
    4. Create a new column (RowID)
    5. Use the following formula in the RowID column, cell 1.  =COUNT(Count$1:Count@row) (Copy down the whole sheet)
    6. Create a new column (Row)
    7. Use the following formula in the Row column.

      ="CTRL/CMD+G " + RowID@row
    8. Link the different sections of the sheet to the ToC in the at the top with the following formula. =Row16 (for row 16)
    9. Try it by pressing the CTRL/CMD + G combination and type the number from the ToC section that you want to jump to.
    10. You can also combine the Row and Task Name column and hide the Count, RowID and Row columns.

    Please see the attached link/screenshot for more information.


    Depending on your country you’ll need to exchange the semi-colon to a comma in the above formulas.

    I hope this helps you!


    Andrée Starå

    Workflow Consultant @ Get Done Consulting


    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

This discussion has been closed.