Link Reference Sheet Dropdown

Rachel HRachel H
edited 12/09/19 in Formulas and Functions
04/01/18 Edited 12/09/19

Is it possible to reference a list on a separate sheet for the user to select as they input data into rows?For example; activity type, client name?

I have created a time sheet and would like users to reference the data in another sheet.

Thank you,

Rachel

Previous1

Comments

  • Mike WildayMike Wilday ✭✭✭✭✭

    No, its not possible to populate a dropdown list from a separate sheet. You can access data from a separate sheet based on a selection from a dropdown using vlookup. Sorry. 

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Hi Rachel,

    Here is a workaround that gives you the possibility to use lists of information and choose from that list inside a sheet (doesn't work with mobile, only desktop)

    I'm utilizing cell-linking for this workaround. The main sheet is linked to the dropdown/list sheet.

    Please see the attached link/screenshot for more information.

    Example of dropdown/list

    I hope this can be helpful for you!

    Best,

    Andrée Starå

    Workflow Consultant @ Get Done Consulting

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • Hi Andree, Can you articulate how the prompt is working with cell linking to enable the functionality shown in the gif file? Thanks

  • Mike WildayMike Wilday ✭✭✭✭✭

    Yes Andree, please share how you completed that. That is very interesting. Do the users have to be shared on the linked sheet to access it and select it? 

  • That's a great workaround, Andrée. Would love to hear how you did it. 

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Hi Thomas,

    Here's a link with a better explanation on how it's done.

    Link Reference Sheet Dropdown

    Let me know if you have any questions or if I can help you with anything else!

    Have a fantastic weekend!

    Best,

    Andrée Starå

    Workflow Consultant @ Get Done Consulting

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Hi Mike,

    Here's a link with a better explanation on how it's done.

    Link Reference Sheet Dropdown

    Let me know if you have any questions or if I can help you with anything else!

    Have a fantastic weekend!

    Best,

    Andrée Starå

    Workflow Consultant @ Get Done Consulting

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Hi Issa,

    Thanks!

    Here's a link with a better explanation on how it's done.

    Link Reference Sheet Dropdown

    Let me know if you have any questions or if I can help you with anything else!

    Have a fantastic weekend!

    Best,

    Andrée Starå

    Workflow Consultant @ Get Done Consulting

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • Andre - this is great. thank you very very much for providing this. so good. thank you x 10000!

  • Awesome. Thanks, sir!

     

    Issa

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Happy to help!

    Have a fantastic weekend!

    Best,

    Andrée

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Happy to help!

    Have a fantastic weekend!

    Best,

    Andrée

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • Hey Andree, Is it possible to have a dropdown box point to the list is a sheet? Im using a form for timesheet data  entry and I would like to manage the list of projects (and task categories) in a separate list!! Thank you in advance. John  

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Hi John,

    Unfortunately, it's not possible at the moment without a third-party integration or a premium add-on, but it's a great idea!

    Please submit an Enhancement Request when you have a moment.

    Have a fantastic week!

    Best,

    Andrée Starå

    Workflow Consultant @ Get Done Consulting

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • While Andree's workaround works... It is just that. As a GC, I need to be able to update project names, employee names, etc. on a regular basis. These lists are used throughout MANY different sheets throughout our organization.


    Smartsheet, please get this future up and running!!! Having to go around to MANY different sheets to update project lists or employee names or product options or...... Is ridiculous. This feature is needed!!! And also seems like it should be a pretty easy one to implement...???...

Sign In or Register to comment.