If Blank and Workday in the same cell?

Hello,

I'd like a Due Date cell to populate based on a date being entered into another Date Completed cell, and add 35 days. That formula works fine: =WORKDAY([Date Completed]44, +35)

The issue I'm running into is that I'd like the Due Date cell in row 51 to stay blank if there isn't a date entered into the Date Completed cell in row 44, instead I get #INVALID DATA TYPE.

I know there is an ISBLANK function that works, and I did try that, but I can't seem to get both functions to work at the same time in the cell. I'm still pretty new to this and I always have struggled a bit with functions/formulas in Excel as well.

I'd love any help I can get.

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!