Skip to content
  • Try Smartsheet

    • Education

    Education

    Connect with Education peers to share Smartsheet solutions, questions, ideas, and best practices that will enable your school, college, or university to work better, at scale.

    👋 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

    ✭
    in Education

    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 ?

    · Share on FacebookShare on Twitter

    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 🚀

      · Share on FacebookShare on Twitter
    • ✭
      edited 11/01/24

      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.

      · Share on FacebookShare on Twitter

    Sign in
    Try Smartsheet

    Quick Links

    Categories

    Engage with peers in
    Education to receive your
    industry badge