Reverse the order of ancestors

I printed the ancestors of the task and the task itself to generate a trail of the task. However I want to reverse the order of the ancestors in order to start with the task then its parents, the grandparent, and the great grandparents etcetera all the way up until the first ancestor. For example, Paint -> 2. Main House / Retreat Space -> Renovation & Design instead of Renovation & Design -> 2. Main House / Retreat Space -> Paint so one can trace what each task is for. How do you reverse the order of the ancestors so that it shows the task, then its successive parents and grandparents etc? There are varying levels of ancestors in this dataset. Appreciate any help you can provide! Thank you.


Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!