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

edited 12/09/19 in Archived 2016 Posts

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.






This discussion has been closed.