Update Status by Start Date

Options

Hi-

I am newer to SmartSheet but not Excel, however I am not finding success with a formula I think I need. I am looking to have the status auto-updated to GRAY if the start date is in the future.

Question 1: What is the formula? I have tried: =IF([Start Date],<[TODAY], "Gray")... but that must not be it.

Question 2: Can I have this formula for Gray and still have users select R/Y/G manually in the field?


Thanks so much for the help!


Christina

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!