Add 2nd additional Criteria to Metric Formula (Open & Blank)


Okay I had a formula that was working perfectly, thanks to @Paul Newcome . And it was:

=COUNTIFS({Status}, @cell <> "", {Workstream Name}, @cell = "")

Now my boss wants to add "Open" from the status column. I tried to change it to:

=COUNTIFS({Status}, @cell <> "", {Workstream Name}, [Metric Name]@row, {Status}, ="Open")

But the result is 0. It should show a result of 2 in this cell

Sherry Fox

Business System Data Analyst

Del-Air Heating, Air Conditioning, Plumbing and Electrical

EAP | Mobilizer | Automagician | Superstar | Community Champion

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!