Display All unique Level 1 Hierarchy from one smartsheet to another

Jett

Hi

I have equipment as a column in EQ needs smartsheet and it is a level 1 when expanded I have all the data below it for that piece of equipment.

I am trying to make a calculations sheet that will only show all the types of equipment (level 1) entered onto the calculations sheet. When I go to the calculation sheet it will only show what is on level one and not everything underneath that piece of equipment.

Andrée Starå

Hi @Jett

I hope you're well and safe!

Can you share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help.

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Jett

Here is the sheet. I have it so that 0 is displayed for the level 1 hierarchy. I want to make a report that will show all the equipment is in the equipment. So on the report it will show SJ 3219 the count of them on the sheet so for right now it will be 1. And Test will show up for the count of 1 and so on. What ever is entered in to the level one. How could I also display the information underneath in a report if I need that in the future.

Will Jeffords

hi @Jett, if you use the “parent” column as a “level” column, then you can set filters on your reports to include whichever levels you want to show there. In the level column use =COUNT(ANCESTORS()) to get the desired number of the level for this. Let me know if you need more help!

Best,

Will