How to put together two formulas to account for blanks

edited 12/09/19 in Formulas and Functions


I have this formula to add 10 days to a date:

=[Date1]@row + 10  

Then I have this formula to leave blank if there is no date:

=IF(ISBLANK([Date1]@row), "")

I need to put them together so if there is a blank the cell stays blank but if not then it needs to add 10 days to the date in [Date1]@row.


Thank you!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!