IF & ISDATE functions
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.
Help Article Resources
Check out the Formula Handbook template!