RYG Formula linked to Status and Start and End Date
Hi Smartsheet Team,
I am looking for help with a formula:
I have a column "Schedule Health" that has RYG Balls I am wanting this to change color based on certain criteria from 3 other columns "Status", "Start Date", "End Date".
Ball is GREEN if "Start Date" is 7 days from today (ie project has not started yet)
Ball is GREEN if "Status" is "Complete"
Ball is YELLOW if "Start Date" is 3 days from today
Ball is YELLOW if "Status" is "In Progress" and "Start Date" is in the future
Ball is RED if "Status" is "In Progress" and "Start Date" is today or past (Project running late)
Ball is RED if "Status" is "In Progress" and "End Date" is today or later (Project started but not completed on time)
Ball is RED if "Status" is anything other than "Complete" at "End Date" for today or late (No body has updated the project and its late to complete)
Can anyone help me please?
Help Article Resources
Check out the Formula Handbook template!