Getting RowID in a sheet?

J. Craig Williams

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.

 

Thanks.

 

Craig

Travis

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

Brilliant.

Thanks Travis!