Formula for Status


I am trying to create a formula to automate the 'status' row in my project grid in SmartSheet. Here is what I am looking for:

Actual start date = Blank, show "Not Started"

If Actual Start Date = is a date and Actual end date = Blank, show "In Progress"

If Actual start date = blank and projected start date > today OR if Actual end date = blank and projected end date > today, show "Overdue"

Actual end date = is a date, show "Complete"

Can anyone help with the nested formula to cover all scenarios?


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!