# How to put together two formulas to account for blanks

edited 12/09/19

Hello,

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!

• ✭✭✭✭✭✭

Hi Lisi,

Try something like this.

=IF(ISBLANK([Date 1]@row); ""; ([Date 1]@row + 10))

The same version but with the below changes for your and others convenience.

=IF(ISBLANK([Date 1]@row), "", ([Date 1]@row + 10))

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• Hi,

Thank you for answering but while working on another issue something told me to do this:

=IF(ISDATE([Completion Date]3), [Date1]@row + 10, "")

and it is working perfectly now.

Thank you!!

• ✭✭✭✭✭✭

Excellent!

Happy to help!

There is almost always more than one way to solve a problem.

A slight modification to the formula if everything is on the same row.

=IF(ISDATE([Completion Date]@row), [Date1]@row + 10, "")

Best,

Andrée

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!