Counting distinct values with two conditions

Options

I am trying to count distinct items that fit two conditions, but I'm getting back an error.

Here is the formula I was trying:

=COUNT(DISTINCT(COLLECT({My Sheet Range 1}, {My Sheet Range 2}, CONTAINS("SEA", @cell), ({My Sheet Range 3}, CONTAINS("In Progress", @cell)))))

If I remove the second condition or use only the second condition it works, but I only want items that contain BOTH "SEA" and "In Progress".

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!