Automating hierarchy indenting using formulas

Monica ✭✭✭✭
edited 12/09/19 in Formulas and Functions

Hello All,

Is there a formula to automate hierarchy?  I am trying to use Smartsheet to create a family tree and dashboard.  I have created a column labeled "Generation Tier" and I am using the people/person symbol to represent where individuals fall in the generations (child=1 person, grandchild=2 people, great grand=3 people, etc.)

It's a very large family so I would like to automate the hierarchy by either:

- automatically indenting the row based on the Generation Tier selected.


- automatically change the Generation Tier depending on the number of times the row has been indented.

All feedback will be greatly appreciated.





generation tier.JPG



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!