Help with Status and Date Columns

Hello, I am having trouble with a formula.

I have 3 date columns, and 1 status column. I would like the status to change with the input of a date in the columns.

Here is the reasoning for the question. I have "Ready Date", A "Start Date", and a "Complete Date". When a date is in the "Ready Date" column, I want the status column to show "Ready", when there is a date in the "Ready Date" and "Start Date" columns, I want the status to show "Started". When there is a date in the "Ready Date", "Start Date", and "Complete Date", I want the status to be "Complete".

I will need all date field to be put in before the status will change, being that someone cannot start until they are ready. Is this something that can be done?

Find more posts tagged with

Finance

Formulas

IT & Operations

Conditional Formatting

Project Management

Comments

JamesR

=IF(ISDATE([Ready Date]#)=0,"",IF(ISDATE([Start Date]#)=0,"Ready",IF(AND((ISDATE([Start Date]#),ISDATE([Complete Date]#)=0,"Started","Complete")))

Try that

J. Craig Williams

There's an error in the previous formula.

The AND is not properly closed.

=IF(ISDATE([Ready Date]23) = 0, "", IF(ISDATE([Start Date]23) = 0, "Ready", IF(AND(ISDATE([Start Date]23), ISDATE([Complete Date]23)) = 0, "Started", "Complete")))

For row 23.

The AND is not really needed, as the previous IF determined the Start Date contains a date.

=IF(ISDATE([Ready Date]23) = 0, "", IF(ISDATE([Start Date]23) = 0, "Ready", IF(ISDATE([Complete Date]23) = 0, "Started", "Completed")))

Craig