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.
Rolling up Conditional Formatting
Smartsheet Community,
I have a normal project in which we have tasks that sometimes go past due. Currently I have conditional formatting set such that if the task is not 100%, and the due date is in the past, that whole task row turns red.
My question is how do i get that past due task (red) to filter up and make the parent task red? By the nature of one task being late, the whole deliverable is considered late. This is necessary because my sheet is over 1000 tasks and I need a quicker way to determine what deliverables are running behind than physically opening every parent task to inspect if a child task is red.
I currently do not have dependencies set accruatly but would consider doing that if need be.
Thanks!
Mattvo76
Comments
-
You can rollup conditionals.
Each row of this sheet checks if any of it's children have made it late, and if any of it's grandchildren. If so it puts a 1 in the appropriate column. It then adds those coulmns up and if that sum is greater than zero, the entire task is late.
https://app.smartsheet.com/b/publish?EQBCT=5705f0b319644bf69fddc4047497cc83
You can edit the "% Complete" of sub tasks and see the roll up. Formulas are available on the bottom row.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 466 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives