Update Status by Start Date



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!


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!