Ancesstors
I can use the below formula to get the ancesstors + task name
JOIN(ANCESTORS([Task Name]@row), " | ") + " | " + [Task Name]@row
This will return to me: Parent 1>Parent 2> Parent 3> Task 1
I'd like it to return the reverse order:
Task 1> Parent 3>Parent2>Parent 1
Answers
-
You can use COUNT with ANCESTORS to find out how many levels there are, and then use INDEX to identify the ancestor at each relevant positions, 1, 2, 3 etc, and then isolate them and put them back together.
If you always have the same number of levels, you could use FIND to parse your existing result into four fields, and then concatenate those four back together in your preferred order.
-
Thanks, James,
What would that look like in this context? I've added a helper column, called Level to make it easy. The helper column now has a level assigned to it. but I am not sure how to formulate the formula to reverse the order
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 438 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 451 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 282 Events
- 32 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!