Help with OR formula

Hi,

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

Answers

  • 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!