Formula for Status

Hello,

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?



Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!