Hi guys,
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?