As other posts for help point out hyperlinks do not transfer when when using functions to look up hyperlink values. Please add support for looking up hyperlink values via formula such that the Display Text and URL transfer to the destination. See details in the links below.
The workaround of linking to a cell in another sheet containing a URL is extremely tedious when working with many rows.
The workaround of using URLs only with no friendly text is unprofessional and gives a poor user experience.
References:
Sign in to see the current vote count, add your own vote, or leave a comment.
You should be able to copy a hyperlink (such as a link to another sheet) by way of a formula. Having to do each one separately is painful and time consuming.
Not having this is a huge disappointment.
I've already got the hyperlink in one sheet, and when I INDEX/MATCH or VLOOKUP that cell, I should be able to pull not just the text but the whole link including the friendly name over. It's so annoying to only be able to get the URL
Cell linking brings over text instead of full functionality such as a hyperlink. see this article:
This is a known issue, but I'm adding my vote for the functionality. Please enable hyperlinks in the data delivered by VLOOKUP and INDEX(COLLECT) functions. It's a deep disappointment that only the text within a cell will show. Others have pointed this out: https://community.smartsheet.com/discussion/comment/439868#Comment_439868 https://community.smartsheet.com/discussion/111231/hyperlink-support-in-index-match-collect-etc-functions?_gl=11knrr3u_gcl_auMTE2MTg0NDU2Ny4xNzE4Mzk1ODUw_gaMTI4MjAyNzAyNC4xNzA5MTUyMjQ1_ga_ZYH7XNXMZK*MTcyMTgyMjcwNS4yMS4xLjE3MjE4MjI3NDAuMjUuMC4w
still not working. what a pain. +1 vote
I have a workflow with nearly 40 automations, half of which are email-based requests for updates with various sets of triggers. While I know the automations work, due to months of testing, when our system went live to the institution, I became very worried that the automations wouldn't run and I'd have no idea whether or…
Description: When users upload multiple photos in one action via the Smartsheet iOS mobile app, all files are assigned the same generic name and timestamp. This makes it difficult to identify individual photos and creates confusion in workflows that rely on accurate, unique file naming. Why This Matters: Industry Standard:…
We are recently starting to use the Smartsheet API and Data Shuttle for maintaining Dashboards. We have discovered that the Data Shuttle workflow will notify the owner when the process completely fails, however it will not send notifications wuth a partial failure indicated by the Yellow Caution sign. Since many of our…
