Status change formula using IF function

Sidonia Posteuca

I have a status column that I would like to set up a formula in to do two things

a) Change status to "Needs Update" when a date in a date column is reached

b) Change status to "Prequalified" when three checkbox columns are all chacked

Here is the formula I have so far:

=IF([Expiration Date]@row = TODAY(), "Needs Update", ""), IF([Safety Review Complete]@row = 1, "Prequalified", ""), IF([Financial Review Complete]@row = 1, "Prequalified", ""), IF([Contracts Review Complete]@row = 1, "Prequalified", "")

The first part of the formula works and status changes to "Needs Update" when singled out. But when put together it comes out to #Unparseable.

Am I using the correct function and order? Is there an easier way to do this. Please help!

Nic Larsen

Try this:

=IF(AND([Safety Review Complete]@row = 1, [Financial Review Complete]@row = 1, [Contracts Review Complete]@row = 1), "Prequalified", IF([Expiration Date]@row >= TODAY(), "Needs Update"))