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.
Expanding and Collapsing Hierarchy/Outline levels
Very much would like to have the ability to expand the hierarchy to a particluar level such as 1,2,3 ... ALL. For my applicaiton Level 1 is PROGRAM, Level 2 is PROJECT, Level 3 is milestone, etc. I need to see the entire sheet open to a particular level. Looking for something that exists in Excel as well as all "outline managers". See below. Press 2 to see all programs; press 4 to see everything.
I would propose you just add another row to "Indent" (rename it Hierarchy) and have a dropdown list with the outline levels and maybe a plus and munus sign to expand all/collapse all. See below
I currently add a LEVEL formula to every sheet which I use to provide level specific conditional format Level 1 Level 2 etc.