# Need empty column blank

✭✭✭

I want to use a formula like this below but if there is no date in the other column to add +14 to, then leave row blank.

=([CONFIRM OW PHOTO DUE]@row + 14)

Need the "14" left blank

Tags:

• ✭✭✭✭✭

=If([Confirm OW Photo Due]@row="","",[Confirm OW Photo Due]@row+14)

• ✭✭✭✭✭✭

@Hollie Green's formula should work. I wrote the same one before realizing that Hollie already provided an answer 😀

Best Regards

Smartsheet CoE, Ignatiuz Software, Exton, PA

• ✭✭✭✭✭✭

I hope you're well and safe!

Strange! It should be blank.

Are you using the exact formula as in your example?

Where is the date in the CONFIRM OW PHOTO DUE column come from?

Be safe, and have a fantastic week!

Best,

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

Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

SMARTSHEET EXPERT CONSULTANT & PARTNER

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

W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35

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

• ✭✭✭

Yes. Thank you. Hope you are having a great week too.

I can confirm I'm using this formula: =([CONFIRM OW PHOTO DUE]@row + 14)

My CONFIRM OW PHOTO DUE column is pulling dates from another 2 sheet using this formula:

=IFERROR(IFERROR(INDEX({Confirm OW Due}, MATCH([STYLE NUMBER (WF)]@row, {OW Style}, 0)), INDEX({PHOVID FINAL OW DUE}, MATCH([STYLE NUMBER (WF)]@row, {OW Archived SKU}, 0))), "")

As you see, the dates are blank in the CONFIRM OW PHOTO DUE, but showing 14 in the PKG RELEASE DATE - ACTUAL column.

• ✭✭✭✭✭

=If([Confirm OW Photo Due]@row="","",[Confirm OW Photo Due]@row+14)

• ✭✭✭✭✭✭

@Hollie Green's formula should work. I wrote the same one before realizing that Hollie already provided an answer 😀

Best Regards

Smartsheet CoE, Ignatiuz Software, Exton, PA

• ✭✭✭

THANK YOU!!! Yall are amazing!

• ✭✭✭✭✭✭

Happy to help!

Let me know if I can help with anything else!

Best,

Andrée

SMARTSHEET EXPERT CONSULTANT & PARTNER

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

W: www.workbold.com | E:[email protected] | 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!