Parent Sort ID Formula
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
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives