Help Using COUNTIF with CONTAINS and the status column

Options

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

  • Jason Albrecht
    Jason Albrecht ✭✭✭✭✭✭
    Options

    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 Albrecht MBA, MBus(AppFin), DipFinMgt

    LinkedIn profile - Open to work

  • Len O.
    Len O. ✭✭
    Options

    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
    Jason Albrecht ✭✭✭✭✭✭
    Options

    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 Albrecht MBA, MBus(AppFin), DipFinMgt

    LinkedIn profile - Open to work

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!