how to overcome blank cell errors when adding days to a date ??

I have added days to a date (=[Date Inputted]@row + [Timescale (Up to __ days)]@row)

However how convert I the error (invalid operation) to a blank cell in the estimated completion date column?? (if error does not work, attempted if formulas but then the days do not add to the date)

Help appreciated :)


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!