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.

Getting RowID in a sheet?

J. Craig Williams
J. Craig Williams ✭✭✭✭✭✭
edited 12/09/19 in Archived 2016 Posts

Is there a way to get the rowid for a different row for a comment.


I have a schedule with a delay of 3d because of something external to the project.

In the Predecesor column I have 23FS+3d because of the delay after completing the task on row 23.

I would like a comment 


="This is delayed because of (reason) after completion of " + RowID(23)


and then if row 23 changes (because I add three rows above it, for example, formula will change with it. I could of course reference the task text directly. But I like numbers for the self-referencing aspect.






  • Travis
    Travis Employee
    edited 01/15/16

    Craig, rather than getting a RowID, you could reference the predecessor value which would change if the predecessor row moves. 


    For example: 


    ="This task is delayed because of row " + Predecessors11


    Would show:


    This task is delayed because of row 9


    Then, if you move row 9, the predecessor will update and in turn, this formula will update with the new row number. 

  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭
    edited 01/15/16


    Thanks Travis!



This discussion has been closed.