Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Creating Hierarchy Levels Automatically

Chris Phair
edited 12/09/19 in Archived 2016 Posts



I have a project plan with a number of hierarchy indents/levels. From what I can see we only have the option to expand or collapse all levels at once. We need to review the project plan at different levels depending on the audience. 


To help review the project plan at the appropriate level I created a new column called level. Each tasks is Level 1, 2, 3, 4 based on the number of indents. The project team can then filter by this column to get the appropriate view. Is there a better way to do this? 

If not, is it possible to set up a formula to automatically number the level column based on the number of indents? 


Any help would be greatly appreciated. 





This discussion has been closed.