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.
Conditional formatting if task is behind schedule
I'm new to Smartsheet so forgive me to ask the question.
How do I setup conditional formatting to a task that is behind schedule? I created 2 lines of conditional formatting already:
1 ) task is 100% complete -> green row
2) end date is in the past and % complete is not 100% -> red row
I'd like to add a third (yellow) formatting for a task which is currently ongoing (so current date is between start and end date), but where the progress is less than where it should be today. Can you guys help me out?