Need assistance creating a formula that automatically changes the "status" based on several fields
Hi! I need help with a formula to automatically update the "status" column based on changes to multiple fields.
The status column has three options: Not started, In progress, and Complete.
If Columns A, B, and C are blank, I want the status to automatically change to "Not started."
If Columns A or B are not blank, I want the status to automatically change to "In progress."
If Column C is not blank, I want the status to automatically change to "Complete."
Also, I currently have the status column set as a drop down menu. Would I need to delete this in order to use a formula? If I use a formula, I would no longer need to manually change this column.
Any assistance is greatly appreciated!
Help Article Resources
Check out the Formula Handbook template!