Parent Sort ID Formula

Ramsay Zaki

I need to create a "Parent ID" that is sorted by the order of the Parent rows. For example, the original order of the Parents is A, B, C, D. If I move around the rows so that the new order is A, C, B, D then the "Parent ID" value should also recalculate (the yellow highlights). This formula needs to be compatible with a Column formula (i.e. it needs to utilize @row)

Genevieve P.

Hi @Ramsay Zaki

I answered your other post with a solution that would actually include a Parent ID like this:

https://community.smartsheet.com/discussion/91087/previous-parent-formula

However, in this instance I was basing the Parent ID off of a System Created auto-number column. Instead, you'll actually want to add an additional "Row Number" column that looks at the System ID column and creates a row number that will auto-adjust as you move rows around:

=MATCH([Row ID]@row, [Row ID]:[Row ID])

Now you have a Row Number that you can use in the Rank column:

=IFERROR(RANKEQ([Row Number]@row, COLLECT([Row Number]:[Row Number], Parent:Parent, "Parent"), 1), "")

Cheers,

Genevieve