IF/AND/ISDATE COMBINATION

Hello all,

I am trying to say If GPD Release Date UK has a date equal or less than GDP 15 Day Target Date-UK and HA Approval UK has a date, then the result should be "On-Time", if not then "Late". But i keep getting #INCORRECT ARGUMENT SET

. What am i doing wrong here?

=IF(AND([GPD Release Date-UK]@row = <[GDP 15 Day Target Date-UK]@row, ISDATE([HA Approval-UK]@row), "On-Time", "Late"))

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!