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.
The above description would work for me.
+1 for me as well. Did this ever go anywhere??
Would also like this feature. Would be very useful to link backed ticket/request type numbers to their actual platforms.
I agree this would be very nice to have.
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.
Jim - Subscribe to The Monday Man
Watch Our Latest Video: A Killer Combo: monday.com, Integromat & Google Sheets - Recurring Tasks Example
Not having this feature makes me want to go back to gsheets!
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.
Is there any progress on this matter?
It would be very helpful to have this capability!
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.
This would be really useful. Any progress or new workarounds?