Using IF formula to drive status


Mine is a little different than what I've found here.  I have 4 columns:  Closed Date and Completion Date, Status column that has 4 choices:  open, closed, complete, overdue and a Due date column.

If closed and completion are blank, the status should be open

If Due date has passed, status should be overdue.

If completion is populated, status should be complete

If Closed is populated, status should be complete

I have a form attached to this, so when someone completes the form, the sheet populates with that information.  When I add these IF formulas, will they be applied to these new rows that are automatically added with the form?

Thank you!




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!