Formula to Automate Stage

Andrea Mayer
Andrea Mayer ✭✭✭✭✭
edited 12/09/19 in Formulas and Functions

Hello -

I am trying to figure out if there is a way to automate the selection of one of three stages (Not Started, In Progress, Completed) based on Start and Due date columns. 

Activities with a Start Date in the future would be 'Not Started', activities with a Due Date in the past would be 'Completed' and anything with a Start Date after today and Due Date in the future would be 'In Progress'. 

I've created the formula below but received and 'Unparseable' error.  As I was building the formula, I also received an 'Invalid Data Type' error - is this because they are not all text/number columns?  The Start and Due date columns are date columns and the Stage column is a dropdown column.

=IF([Start Date]@row, >=TODAY(), "Not Started", IF(AND([Due Date]@row, <=TODAY(), "Completed", "In Progress")))

Any help is appreciated. Thank you!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!