Adding HYPERLINK (to other smartsheet) inside a drop down menu

simon_z
edited 12/09/19 in Smartsheet Basics

Hi I have multiple employees name in my drop down menu. They all have an individual employee page. Could we add a link to their name when I create my drop down menu , inside edit column properties?

 

thank you

Comments

  • Chris McKay
    Chris McKay ✭✭✭✭✭✭

    Hi Simon,

    if you are asking whether it’s possible to configure a hyperlink to another Smartsheet for each dropdown menu item selected, then the answer is no.

    you could set it up in a round about way by adding a column to the right that will pull a hyperlink stored on the relevant employee page by setting up an INDEX MATCH formula to look at the selected dropdown value and find the hyperlink.

    kind regards,

    Chris McKay