Countifs formula looks at two columns, multi items in one of the columns

Hi,

Always appreciate your time.

I feel like this shouldn't be hard - end of day eyes maybe?

Column #1 count if a particular Stakeholder name

Column#2 count if Status = "Open" or "Ongoing"

I'm getting errors with these formulas

=COUNTIFS([Primary Stakeholder]:[Primary Stakeholder], "P&T", Status:Status, "open", Status:Status, "Ongoing")

=COUNTIFS([Primary Stakeholder]:[Primary Stakeholder], "P&T", Status:Status, "Open", OR(Status:Status, "Ongoing"))

=COUNTIFS([Primary Stakeholder]:[Primary Stakeholder], "P&T", Status:Status, "Open", OR,COUNTIF(Status:Status, "Ongoing"))

Tags:

Best Answer

  • Jon Mark H
    Jon Mark H ✭✭✭✭✭
    Answer ✓

    So close @NCharleb !

    It's a little funky how it works.

    You want to go with:

    =COUNTIFS([Primary Stakeholder]:[Primary Stakeholder], "P&T", Status:Status, OR(@cell = "Open", @cell = "Ongoing"))


    Let me know if that works or if you have any other things you need help with!


    -Jon Mark

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!