Counting distinct values with two conditions

Regen
✭✭
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".
Tags:
Best Answer
-
Remove the opening parenthesis from before range 3 and one of the closing parenthesis from the end.
Answers
-
Remove the opening parenthesis from before range 3 and one of the closing parenthesis from the end.
-
Thank you so much, it worked!
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!