Using COUNTIFS with CONTAINS

Welcome to the New Smartsheet Online Community


You’ll notice that things have changed a bit. If you need help getting oriented, please take a look at the posts here in the Welcome to the Community category.

Using COUNTIFS with CONTAINS

Hello,

I have a contact column where some rows have more than one person assigned to a task. I want to count the number of tasks assigned to any given individual. This is the formula that I have created to do this:


=COUNTIF(CONTAINS("Bernie Sanders", [Assigned]:[Assigned]), "True")


The return value that I get is "0," which is not correct.

Is there another formula that I can try?

Best Answer

Answers

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    It's a syntax issue. Try this...


    =COUNTIFS(Assigned:Assigned, CONTAINS("Colonel Sanders", @cell))


    (changed the name because I personally like fried chicken better than politics 😂)

  • This is also returning a "0" :(

  • This formula is returning unparseable.

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    @Jenna Corso Hmm... That's odd... Can you copy/paste the exact formula from your Smartsheet to here along with a quick screenshot of your column names?

  • @Paul Newcome I forgot the comma before FIND--it works! Thank you so much for your help!

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    Good catch. Happy to help! 👍️

Sign In or Register to comment.