Dates Formula (IF?)

Gerardo_Clarke
edited 12/09/19 in Formulas and Functions

Dear, I need help

I need a formula that activates a status dependent on a date. I mean, it automatically gets the corresponding color if a few days have passed after sending a quote.

Example, if 3 days have elapsed since the date the quote was sent, the status should be automatically set to Yellow

And if 5 days have passed since the date the quote was sent, the status will turn red.

I can't find the right formula. I appreciate help. Thank you.  (see image)

 

Captura de Pantalla 2019-08-26 a la(s) 13.52.53.png

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!