Help Using COUNTIF with CONTAINS and the status column

Len O.

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!

Jason Albrecht

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?

Len O.

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.

Jason Albrecht

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?