Skip to content
  • Try Smartsheet

    • Formulas and Functions

    Formulas and Functions

    Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

    Contact List/Dropdown

    ✭✭
    in Formulas and Functions

    Needing to put contact information into a cell from a dropdown list where it will list the name, phone number and email address.

    · Share on FacebookShare on Twitter

    Best Answer

    • Overachievers
      Answer ✓

      Hi there, unfortunately this isn't a function - you can add name and email to a contact but you will have to use other columns to display their phone number.

      However, if the contact has a smartsheet license, makes an account and fills in all their details, everything will display when you hover over the contact:

      image.png


      · Share on FacebookShare on Twitter

    Answers

    • Overachievers
      Answer ✓

      Hi there, unfortunately this isn't a function - you can add name and email to a contact but you will have to use other columns to display their phone number.

      However, if the contact has a smartsheet license, makes an account and fills in all their details, everything will display when you hover over the contact:

      image.png


      · Share on FacebookShare on Twitter

    Sign in
    Try Smartsheet

    Help Article Resources

    Create and edit formulas in Smartsheet

    Formula combinations for cross sheet references

    Smartsheet functions list

    Quick Links

    Categories

    Want to practice working with formulas directly in Smartsheet?

    Check out the Formula Handbook template!

    Trending in Formulas and Functions