Help with formula if cell is blank

Dartwohl ✭✭✭✭
edited 12/09/19 in Formulas and Functions

I'm using the following formula to piece together a date in a text/number cell:

=IF(MONTH([Sale Date Form]@row) < 10, "0") + MONTH([Sale Date Form]@row) + "-" + IF(DAY([Sale Date Form]@row) < 10, "0") + DAY([Sale Date Form]@row) + "-" + YEAR([Sale Date Form]@row)

It's working great, unless the "Sale Date Form" cell is blank,  then I get an "Invalid Data Type" error.  

Please help with adding logic to this that leaves this cell blank if "Sale Date Form" is blank.

Thanks in advance!  



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!