Countifs function when there are multiple contacts in a cell

Options

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.

Best Answer

Answers