Update Status by Start Date

Christina Moss

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

Paul Newcome

Try this...

=IF([Start Date]@row > TODAY(), "Gray")

You can only have a formula OR manual entry. If you have a formula in a cell and then someone manually selects a different color, that will erase the formula and the cell will remain manual entry until the formula is put back into the cell.

Paul Newcome

Try this...

=IF([Start Date]@row > TODAY(), "Gray")

You can only have a formula OR manual entry. If you have a formula in a cell and then someone manually selects a different color, that will erase the formula and the cell will remain manual entry until the formula is put back into the cell.

Christina Moss

FANTASTIC! Thank you for the response!

I guess I need to decide if I want to be fancy or not.

I really appreciate the help!

CM

Paul Newcome

Happy to help. 👍️