How can I avoid getting this msg (#Invalid operation) when one of the dates is empty

Options

Hello

How can I avoid getting this msg (#Invalid operation) when one of the dates is empty

My formula is: =[Site survey request date]@row - [Site survey Actual date it was completed]@row

Any help is appreciated…

Thank you

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!