Status Update Formula
I am new to Smartsheet and like to learn quickly from your experience. I have tried to update the status column based on the % completed byt this simple logic
0%--. Not started,
Greater then 0 % but < 100% - WIP
100% - completed
How I can make this more meaningful by connecting with duration or end date ?
status = Not started- Delayed (ORANGE COLOR) - if % complete = "0" and today's date is greater than start date-
status = Overdue- Delayed (RED COLOR) - if % complete < "100" and today's date is greater than end date-
status = WIP - AT RISK (YELLOW COLOR) - if % complete is Greater then 0 % but < 50% and Time elapsed 50% of duration
I am not able to figure this out. Will you please help ?