Contains Function cannot find value for contact list data type

Anthony893 ✭✭
edited 01/03/24 in Formulas and Functions


I'm trying to use the COUNTIF and CONTAINS functions to count the values in the percent column based off the values in the Names column with the contact list column type.

Here is the formula I have so far:

=SUMIF(Names1:Names3, CONTAINS("Anthony", @cell), Percent1:Percent3)

And here is the data:

When I change the data type to text, it works. But when I have the Names column set to the contact list data type, it returns 0 (I'm assuming that means the CONTAINS function found no matches).

Is there a different function I should be using other than CONTAINS that will work with contact lists?




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!