Status Formula

Hi all,

I am struggling to create a formula that works and wonder if you can help me….


Duration Equal to or Less than 0, Gray.

Duration Greater than 0 but “Email Sent” & “Return Old Device” unchecked, Yellow.

Duration Greater than 20 but “Email Sent & “Return Old Device” unchecked, Red.

Duration Greater than 0 and “Email Sent” & “Return Old Device” is checked, Green.

I want gray to mean not started, yellow in progress, red overdue, and green complete. If that makes sense. Thanks in advance for your help.




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!