How to see only the lowest level tasks in Card View (i.e. how not to see any parent tasks)

Options

Is it possible to view only the lowest level tasks in a roll-up no matter what level they are? The level selection only allows me to view one level at a time.

In other words, one task roll-up may have 3 levels and another one may have 5 levels. How can I see all of the level 3's and all of the level 5's and see none of the parents.

Tags:

Answers

  • Monique_Odom_Comcast
    Monique_Odom_Comcast ✭✭✭✭✭✭
    Options

    Hello @JackieBGCC!

    For this one, I would recommend creating a helper column to identify the lowest level rows. Then you can use that column to filter a report and switch the report to card view. This should give you what you're looking for!

    For the helper column, you could use a column formula that counts how many children each row has and then filter the report to only show the ones that have 0.

    If my comment helped you, please help others by marking it as an accepted answer and consider helping me by clicking the 💡Insightful or ❤️Awesome buttons below!

    Monique Odom

    Business Process Excellence Manager

    Smartsheet Leader & Community Champion

    Pronouns: She/Her (What’s this?)

    “Take chances, make mistakes, get messy!” – Ms. Frizzle