Help with OR formula



I'm trying to use the formula as below, it does not seem to work for me.

=COUNTIFS({product type}, "type1", OR({product type}), "type2", {supplier}, $suppliername1, {product or service}, "product", {status}, "")

Basically I want to count the number of blank status that are a "product", within type1 and type2 for product type.

The {product type}, {supplier}, {product or service} and {status} are reference from another single sheet.

Best Answer


  • HueyD
    HueyD ✭✭

    thank you very much, the formula works :)

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!