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
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!