So I have a formula that returns a text string based on a status, which works fine (it is a simple nested IF statement)
What I’d like is to convert that text result into a clickable hyperlink.
So what I’d really like is the implementation of the HYPERLINK() function in excel.
To be clear the text is dynamically set based on user choice, so the link column isn’t suitable.
Did this ever go anywhere? +1 for this. I’d love a URL builder style column where i can build a URL based on the data in other columns then make that a clickable link. The formula column works for this but i still need to copy + paste the link into the browser.
For some, one possibility would be using right-click on the formula cell to copy the link. Both Edge and Chrome will then allow you to right-click in the address bar to paste and go to the link. Edge allows you to use Ctrl+Shift+L as well.
Would like this too. If you can’t achieve this, then at least allow the Link column type to reference the value in the formula column for the link URL.
I was able to get around this limitation, but I can’t say that it will work for everyone’s use case.
My workaround was to use an automation to post an UPDATE to the item under certain conditions. The text of the update includes a dynamically constructed URL that does show in the update as a Hyperlink.
This workaround also helped me overcome a challenge with Zendesk integration that I was encountering.
Unfortunately, it doesn’t put the link in the table, but it does put it in the item Update which may result in notifications going out to item subscribers. It’s a workable solution for us until more flexibility arrives in Monday.com.