Traffic Light based on % Completed and Due Date


Hello, I would like you to help me with the following semaphore formula. My premises are:

1.-Green if the activity has not started yet

2.- Green if the activity has already started but there are still 10 days left and it is more than 50% complete

3.-Yellow if less than 75% of the activity has been completed and there are 10 days left before the due date

4.-Red if there are less than 3 days left and the activity is not yet completed

5.- Red if the date has already expired and is not 100% finished

Thanks in advance

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!