Countifs function when there are multiple contacts in a cell

Oleksiy Yefimov

Hi Smartsheet Team,

I have a question. I try to use "Countifs" function when there are multiple contacts in a cell. For example, I use cross sheet reference and need to count how many times each person is indicated in the "Assigned to" column. There are multiple team members indicated under "Assigned to" column.

My current formula is as follows:

=COUNTIFS({Smartsheet Range 1}, CONTAINS("Person A", @cell))

Unfortunately, this formula does not work in my case.

Hope for any advice.

Thanks.

Kind regards and have a great day.

Oleksiy Yefimov

@Nic Larsen

Hi Nic,

Thanks a lot, it finally worked!

Kind regards and have a great rest of the day!

Nic Larsen

I sometimes have better luck with HAS

=COUNTIFS({Smartsheet Range 1}, HAS(@cell, "Person A"))

Oleksiy Yefimov

@Nic Larsen

Hi Nic,

Thanks a lot, it finally worked!

Kind regards and have a great rest of the day!