ISBOOLEAN DATE FORMULA RETURNING BLANK

BettyJo

I would like for the Conduit Ship Schedule column to return a date 14 days prior to the Forecast Production Date IF the Conduit on Inventory box IS NOT checked.

So I wrote my formula that if checked, returns blank, if not, returns date. However, all results are blank. What am I missing?

bisaacs

Hey @BettyJo,

I would change the IF statement to this:

=IF([Conduit on Inventory]@row = 1, " ", [1. Forecast production date]@row - 14)

That should work!

bisaacs

Hey @BettyJo,

I would change the IF statement to this:

=IF([Conduit on Inventory]@row = 1, " ", [1. Forecast production date]@row - 14)

That should work!

BettyJo

That worked! Thank you!