If blank OR value, then

vmoody

Hello everyone,

I am new at creating formulas and can't seem to get this right. I've tried so many ways and I am officially confused. I can get it to work with one criteria but not two.

If value in [Document Status] is blank OR <> "draft then uncheck box

if any other value, check box

Here's one of the formulas I tried =IF(ISBLANK(OR([document status]@row<>“draft”), 0,1))

Thank you in advance for your help!

MichaelTCA

Hello @vmoody

You are very close!

Flip a couple things around and:

=IF(OR(ISBLANK([document status]@row),[document status]@row<>"draft"),0,1)

MichaelTCA

Hello @vmoody

You are very close!

Flip a couple things around and:

=IF(OR(ISBLANK([document status]@row),[document status]@row<>"draft"),0,1)

vmoody

Michael! Thank you SOOO much! I was driving myself crazy trying to figure it out. It works great!😃

MichaelTCA

Perfect! Glad it worked.