Help Using COUNTIF with CONTAINS and the status column
Hi!
I figured out the formula to count the row from another sheet if the cell contains a certain word, =COUNTIF({Current Project List Range 2}, CONTAINS("Events", @cell))
However this counts all the items regardless of Status. I'd like to get it to count only if the Status Column is also showing "In Progress" or "Not Started".
Thank you!
Answers
-
Hi Len,
Would the COUNTIFS function work for you?
Others have also tried nesting AND and OR functions with varying degrees of success.
Hope this helps?
Hope this helps and that you have a great day,
Jason
-
Thank you for your response Jason! Do you have an example of how I would use the AND function? Every time I've tried, I get an #UNPARSEABLE error.
-
Hi Len,
In regard to your original question I personally would gravitate to the COUNTIFS (not the COUNTIF) function. The "S" on the end makes all the difference.
In regard to the AND function, Smartsheet has a writeup here. You'll note the example only uses the IF function.
There are also some good examples via the second link in my first response.
Maybe share with us an example of your #UNPARSEABLE formula for the community to help you out?
Hope this helps and that you have a great day,
Jason
Help Article Resources
Categories
Check out the Formula Handbook template!