Welcome!

Formula is not pulling contact list name

Hi,

My formula used to work when the field was just a drop down list. Now that we changed it to a Contact list, the formula stopped working. I tried listing the persons full name, tried adding the email address with the name, just like it is in the contact list. but still i am not getting any results.

=COUNTIFS({2020 TRACKER Range 2}, "Danita", {2020 TRACKER Range 1}, [Column2]2)

Find more posts tagged with

Comments

Amit Wadhwani

Hi Peggy,

Give this a try =COUNTIF({2020 TRACKER Range 2}, FIND("Danita", @cell) > 0)

Paul Newcome

Which range is the one pointing at the contact column?

Peggy

I used the column range =COUNTIFS({2020 TRACKER Range 2}, "Danita", {2020 TRACKER Range 1}, [Column2]2). I can try the suggestions that Amit provided.

Peggy

Amit's suggestion is not working for this formula.

=COUNTIFS({2019 TRACKER Range 2}, FIND("Danita" @cell) > 0, {2019 TRACKER Range 3}, "Stage 0 Onboarding Start")

Paul Newcome

Is range 1 or range 2 pointing at the contact column?

Peggy

range 2

Paul Newcome

The FIND function is case sensitive. Also double check that the spelling for "Stage 0 Onboarding Start" matches exactly as well.

Are you able to provide a screenshot of both sheets that shows the data that SHOULD be counted as well as the count you are actually getting?

Sign in to join the conversation!

Quick Links

Trending discussions

Week Number Year to Year
I've got the following formula in a Check Box column to check when something is due in the Next 3 weeks. =IFERROR(IF(AND(WEEKNUMBER([Projected Cleaning Date]@row ) = WEEKNUMBER(TODAY()) + 3, YEAR([Projected Cleaning Date]@row ) = YEAR(TODAY())), 1), "") I have them for 2 weeks, 3 weeks, 4 weeks, and 5 weeks. These stopped…
Use Sheet Summary as cell reference for a different sheet
I'm using salesforce connector to pull my team's hours information in real-time. The Salesforce connector sheet contains sheet summaries that I'd like to use a cell reference for a different sheet. I can't seem to find the best way or formula to do this. I don't want to use a dashboard with report widgets because I prefer…
Issues with IF formula
I have two formulas which work well independently, but when I combine them they don't. formula 1: =IF(YEAR([Joined date]@row ) = 2025, JOIN(COLLECT({Membership Survey 2025 - Experience}, {Membership Prioritisation Survey 2025 - Org}, [Organisation name]@row ))) formula 2: =IF(YEAR([Joined date]@row ) < 2025,…