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.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!