Help with a function

Christopher Warren

I'm trying to have the Status column drop down pick Processing if date is after today's date, & trying to have the Status column drop down pick LATE if date is before today's date.

But if the date is blank, what would need to be added to the function to have the drop down not choose anything?

Would there need to be an "=IF(ISDATE"

Leibel S

@Christopher Warren

Your parentheses is slightly off:

=IF([Estimated Completion Date]@row <TODAY(), "LATE", IF([Estimated Completion Date]@row >TODAY(),"Processing"))

I will point out that if the Estimated Completion Date is TODAY, then this formula will not return anything.

Leibel S

@Christopher Warren

See below, as mentioned previously, this does not account for Estimated Completion Date being today.

=IF([Estimated Completion Date]@row <> "", IF([Estimated Completion Date]@row < TODAY(), "LATE", IF([Estimated Completion Date]@row > TODAY(), "Processing")), "")

Leibel S

@Christopher Warren

Your parentheses is slightly off:

=IF([Estimated Completion Date]@row <TODAY(), "LATE", IF([Estimated Completion Date]@row >TODAY(),"Processing"))

I will point out that if the Estimated Completion Date is TODAY, then this formula will not return anything.

Christopher Warren

@Leibel Shuchat

Thanks so much.

But if the date is blank, what would need to be added to the function to have the drop down not choose anything?

Would there need to be an "=IF(ISDATE"

Leibel S

@Christopher Warren

See below, as mentioned previously, this does not account for Estimated Completion Date being today.

=IF([Estimated Completion Date]@row <> "", IF([Estimated Completion Date]@row < TODAY(), "LATE", IF([Estimated Completion Date]@row > TODAY(), "Processing")), "")