👋 Welcome! Introduce yourself and connect with your peers in Education to receive your industry badge.
Count multiple names in one cell without knowing new entry
I have multiple names in one cell and no fixed list of names as if whose names will be there in the new entry and want to count unique names. How to do that using countif ?
Comments
-
@Govinda Is there a screenshot example of the cell? Trying to determine if the column is Contact List or Text/Number as well as the entry format.
Erin Horiuchi Green, MBA, LSSYB, PSMI
Process Manager
Syneos Health
Please kindly like ❤️, upvote ⬆️ and/or mark ✅ any of my contributions that have provided value.
Core App and Project Managment Certified 🚀 -
Hi Erin, it is Text/ Number and entry is received from a from which will be filled by other people so that they can add multiple names in the Name entry.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 463 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives