IF & ISDATE functions

dlittl02

I'm trying to create a function that will basically trigger another cell if a date column has an entry filled

I want it say "If there's a date entered in this cell, change "x" cell to Complete

I had this =IF([Actual Date]@row = ISDATE(''), "Complete")

I'm sure there's a way to do what I need but just confused on syntax. Please help.

Kelly Moore

Hey @dlittl02

This is the syntax you need

=IF(ISDATE([Actual Date]@row), "Complete")

This will change the 'X' cell to Complete if [Actual Date]@row is a date, otherwise the X cell will remain blank.

cheers,

Kelly

Kelly Moore

Hey @dlittl02

This is the syntax you need

=IF(ISDATE([Actual Date]@row), "Complete")

This will change the 'X' cell to Complete if [Actual Date]@row is a date, otherwise the X cell will remain blank.

cheers,

Kelly