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)
Comments
-
Hi Peggy,
Give this a try =COUNTIF({2020 TRACKER Range 2}, FIND("Danita", @cell) > 0)
Best Regards
Amit Wadhwani, Smartsheet Community Champion
Smartsheet CoE, Ignatiuz Software, Exton, PA
https://www.linkedin.com/in/amitinddr/
Did this answer help you? Show some love by marking this answer as "Insightful 💡" or "Awesome ❤️" and "Vote Up ⬆️"
-
Which range is the one pointing at the contact column?
-
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.
-
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")
-
Is range 1 or range 2 pointing at the contact column?
-
range 2
-
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?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- 10.6K Get Help
- 63 Global Discussions
- 68 Industry Talk
- 385 Announcements
- 3.5K Ideas & Feature Requests
- 55 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives
Check out the Formula Handbook template!