Update a Status Formula
I currently have the following formula for a status column:
=IF([Expiry Date]78 < TODAY(), "Expired", IF([Expiry Date]78 < TODAY() + 60, "Expiring Soon", "Current"))
However, I have now added a column that is a checkbox titled "Re-Training Not Required" and another checkbox column titled "Inactive" (If the checkbox is checked it will do the formula as above)
Is there anyway to add to the formula that if the 're-training not required' is checked it will mark status column as 'current' and if 'inactive' is checked it marks the status as 'inactive'? (If the checkbox is checked it will do the formula as above)
Thanks for your help.
Help Article Resources
Check out the Formula Handbook template!