Adjusting formula for created Row# to not begin from 1 e.g. begin with 88, then 89, 90... etc.

adimunir

Hi,

For context I've created a report that draws from 4 sheets as a programme level plan. I encountered an issue with the predecessors not reporting clearly from source sheet. For those who haven't encountered this issue, smartsheet uses the row# to assign predecessors, hence with multiple source sheets only the amount of predecessors are shown and not the specific row#.

Using the link below I managed to use the formulas discussed to solve this issue.

https://community.smartsheet.com/discussion/comment/345918#Comment_345918

The issue I have now is that the predecessors can't be linked between sheets at report level as tasks begin from Row 1 in each sheet an hence predecessors are assigned to individual sheet. A solution to this can be if there is a way to adjust the Row# to begin with the proceeding Row# from the previous sheet e.g. 88. Formula for Row# used: =MATCH([Task Name]@row, [Task Name]:[Task Name], 0)

Jason Tarpinian

If you just need to reference the last row #, it could be something simple like:

"Adjusted Row #" =MAX({Row # Range})+[Row #]@row

Where {Row # Range} references the previous sheets "Row #" column. For my example below, Row ID is the system column, Row # =MATCH([Row ID]@row, [Row ID]:[Row ID], 0), and then the "Adjusted Row #" is where you would put ^that formula (I didn't bother referencing another range, so replace 88 in my example below with your previous sheet's range)

Jason Tarpinian

If you just need to reference the last row #, it could be something simple like:

"Adjusted Row #" =MAX({Row # Range})+[Row #]@row

Where {Row # Range} references the previous sheets "Row #" column. For my example below, Row ID is the system column, Row # =MATCH([Row ID]@row, [Row ID]:[Row ID], 0), and then the "Adjusted Row #" is where you would put ^that formula (I didn't bother referencing another range, so replace 88 in my example below with your previous sheet's range)

adimunir

That's brilliant Jason, thanks!

Do you know how I would adjust the formula for the pred#1, pred#2 etc. to accommodate for the inclusion of the adjusted row# rather than original row #.

Jason Tarpinian

That you wouldn't be able to do, by default the predecessors are looking at the system row. You unfortunately wouldn't be able to point it at a custom column.