Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Automatic Staff Details

Matt Simmon
edited 12/09/19 in Archived 2015 Posts

Hi All


Is it possible to have detials auomatically filled in for a person.


Eample i select person x from a drop down list to work on a course, the spreadhseet then gets the phone number and email adress of person x from a sperate spreadhseet and auto fills it.


Thnaks in advacne for your help.




  • JohnHinkle
    JohnHinkle ✭✭✭✭✭✭
    edited 07/28/15

    It sounds like you are looking for a VLOOKUP functionality, which Smartsheet does not support. If you use Contact List columns and the user exists in your contact list or in your account under User Management, then when you start typing the name in your sheet, Smartsheet will autofill the user's name and email address but there isn't an option for phone numbers. 

  • Tom Lenham

    What about enabling a conditional formatting rule so you can set "if person A is entered in column 3, then enter email address on column 4"?


  • JohnHinkle
    JohnHinkle ✭✭✭✭✭✭

    Tom you can do that, just a couple things...


    You cannot have formulas in a contact list column, so it would have to be a text/number column 


    If you have a lot of contacts, your formula would be huge. Which is fine, just something to think about! 

This discussion has been closed.