Using "If" with dates

Hi all,

I'm working on a sheet where I'd like to reference a start date for a task and then, based on the current date, auto-populate another column with a status update (not started, in progress, overdue, etc.).

I think I want an "IF" statement-something like "=IF([reference column])>today, "Not Started") but I"m 100% confident that I'm missing some bits there.

Here's a screenshot of some of my data (ignore the "health" column). I want "Start Date" to be compared to today's date and generate a status in the "Test Status" column (not started, in progress, overdue).

Thanks much for all of your help and suggestions!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!