How to see only the lowest level tasks in Card View (i.e. how not to see any parent tasks)
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.
Answers
-
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-Stearn
Business Process Excellence Manager
Smartsheet Leader & Community Champion
Pronouns: She/Her (What’s this?)
“Take chances, make mistakes, get messy!” – Ms. Frizzle
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 220 Industry Talk
- 458 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 137 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives