"Invalid Data Type" Error - Need Formula Help!

Ashley Pierce
Ashley Pierce ✭✭✭✭
edited 07/04/23 in Formulas and Functions

I am trying to add 3 years from the "Date Completed" column; however, I'm getting the "INVALID DATA TYPE" for the cells where "Date Completed" are blank. I'd like for the "Date of Renewal" to stay blank if the Date Completed is blank.

=DATE(YEAR([Date Completed]@row) + 3, MONTH([Date Completed]@row), DAY([Date Completed]@row))

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!