CountIfs

Kim Michael

I am trying to come up with a formula to count all lines in a schedule that have a specific persons name in the "Assigned To' column and if the "Past Due Tasks Alert" flag is raised. Please keep in mind that there could be numerous names in the "Assigned To" column .

My current formula that I have doesn't seem to be working. The results in my summary sheet for the formula below is "0". It should be 2 based off my table above.

=COUNTIFS([Assigned To]:[Assigned To], CONTAINS("Mackenzie Williams", @cell), [Past Due Task Alert]:[Past Due Task Alert], =1)

Kim Michael

Solution found! Thanks everyone. The winner for today is

=COUNTIFS([Assigned To]:[Assigned To], FIND("Mackenzie Williams", @cell) > 0, [Past Due Task Alert]:[Past Due Task Alert], =1)

Paul Newcome

The CONTAINS function gets a little wonky and doesn't like to work with contact type columns. Try swapping it out with a FIND function.

=COUNTIFS([Assigned To]:[Assigned To], FIND("Mackenzie Williams", @cell) > 0, [Past Due Task Alert]:[Past Due Task Alert], =1)

L_123

2 ways to do this

contains("Mackenzie Williams",join(@cell,"*"

or the easier way

has(@cell,"Mackenzie Williams"

L_123

@Paul Newcome welp. I guess there's 3 ways to do this hahah

Paul Newcome

@L@123 Haha. I hadn't thought of using the JOIN or HAS functions. I just go straight to FIND when dealing with Contact type columns.

Kim Michael

Solution found! Thanks everyone. The winner for today is

=COUNTIFS([Assigned To]:[Assigned To], FIND("Mackenzie Williams", @cell) > 0, [Past Due Task Alert]:[Past Due Task Alert], =1)

Paul Newcome

Happy to help. 👍️