Need empty column blank

Shawn_K2

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

Hollie Green

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

Amit Wadhwani

Hi @Shawn_K2

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

Andrée Starå

Hi @Shawn_K2

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!

Shawn_K2

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.

Hollie Green

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

Amit Wadhwani

Hi @Shawn_K2

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

Shawn_K2

@Hollie Green @Amit Wadhwani

THANK YOU!!! Yall are amazing!

Andrée Starå

@Shawn_K2

Happy to help!

I saw that Hollie had answered already!

Let me know if I can help with anything else!

Best,

Andrée