If blank OR value, then

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!

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!