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

simon_z
✭
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
-
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