Using 'OR' Function within 'COUNTIFS'

Hi, I am having trouble with a formula.

I am trying to count the number of items with a Status of "1.6 QUOTE SENT" AND "2.1 DRAFT", but I'm unable to get the formula to function. I'm having trouble correctly parsing the OR function in the formula:

=COUNTIFS({3. LIVE ORDERS Status}, OR("1.6 QUOTE SENT", "2.1 DRAFT"), {3. LIVE ORDERS Quote Sent}, DATE@row)

The formula works correctly when I am not using the OR status

=COUNTIFS({3. LIVE ORDERS Status}, "1.6 QUOTE SENT", {3. LIVE ORDERS Quote Sent}, DATE@row)

Any help would be greatly appreciated.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!