Display All unique Level 1 Hierarchy from one smartsheet to another



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å
    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!


    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!


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

    W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

  • Jett
    edited 04/23/24

    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
    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!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!