Multiple Contacts Formula

Tera K

Hello Smartsheet Community!

I have a grid or sheet where we have listed out all of our projects in columns across the top and all of the supporting roles to each project down the left side. I have created a sheet to calculate all of these people but when I do the formula ( =COUNTIFS({CFPT Matrix - All Projects Range 3}, HAS(@cell, Attendee@row)) it appears that SS is missing a few members who are in the multiple cells. When entering the first half of the formula I was selecting all the cells in the reference sheet hoping to grab all the names.

Does it matter if the columns are set up differently? Half the sheet is just Text/Number type and the other is set up as Contact List with the multiple contacts per cell turned ON. Is that maybe what is causing the sheet to not reflect the totals accurately?

Thank you!

Tera k

jmyzk_cloudsmart_jp

Hi @Tera K

Do you still have the problem?

I tested your formula, =COUNTIFS({Range of Text/Number columns and Multi-select Contact columns}, HAS(@cell, Attendee@row)), and found the formula working with no problem. (I tested in the Sheet Summary field, but the formula structure is the same.)

I tried with =COUNTIFS({Range}, CONTAINS(Attendee@row, @cell), but it counts only TEXT/Value columns.

The results are the same whether I set the [Attendee] column to Text/Value or a Contact list.

https://app.smartsheet.com/b/publish?EQBCT=32c123748df0494a8ebc8f15dbdbc6f7