Mixing ands and Or within an If formula

Options

I am trying to get if purchased as stock is not checked AND a sting of ORs, then check this box.

=if(and([Purchased as Stock]@row=0,if(or(islank(Client@row),isblank(Item@row),isblank(Quantity@row),isblank([Purchase Price]@row),1,""))

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!