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.



 

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!