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
As one of the system admins, it is absurd to me that I cannot view or have access to all of the items created in my organization. We have over 11,000 reports, sheets, and dashboards and I can't see them. I have no visibility to if people are using our plan for their own personal use, or what kind of work is going on unless…
Our sheets & workspaces require many people to have Admin level capabilities, which means that when someone requests access to a sheet or workspace, that email is sent to every Admin. This causes confusion and higher risk of no access granted (because people have learned to ignore the emails) or the wrong level of access…
Today you can create a form and add logic. If that logic requires that requests need to be made for X days in the future you can add logic to help. For instance is the date requirement is not met you can hide fields so that information cannot be submitted completely. You can display a banner if date requirements are not…
