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
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.

 

Matt

Tags:
· Share on FacebookShare on Twitter

Comments

  • 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. 

    · Share on FacebookShare on Twitter
  • Tom Lenham
    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"?

     

    · Share on FacebookShare on Twitter
  • 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! 

    · Share on FacebookShare on Twitter
This discussion has been closed.

Categories