Health of Work/Color Formula Question
I am new to Smartsheet and have no idea on how to properly articulate the following rules in a formula.
I am using the colors RYGB and following statuses:
• New = green, if end date is one week away yellow, If end date has passed red
• In progress = if % complete is between 80-90% and not overdue green, otherwise yellow if % complete is <80% and end date is <1 week away;
• Blocked = red
• Review = green, if end date is one week away yellow and % complete is <90%, If end date has passed red
• Done = blue
Help Article Resources
Check out the Formula Handbook template!