Parent Sort ID Formula

Ramsay Zaki
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)



Answers

  • Hi @Ramsay Zaki

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


    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

    Join us at Smartsheet ENGAGE 2024 🎉
    October 8 - 10, Seattle, WA | Register now