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?
Help Article Resources
Check out the Formula Handbook template!