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.
This could be really useful. Just spoke with someone who wants to link to the item id in a mirror column but that it would actually be clickable to the item. The thought was to use a formula of the board and then add the itemID but then it needs to be clickable…
+1 from me. I simply like to create a clickable link using a formula and two columns, one for a Link to the shipper website and the other a text, providing the tracking number for a shipment. Something like this: HYPERLINK({Link_URL_Column}, {Text_Tracking_No_Column})
You’ll be able to import/export your data (and boards with items as well) and work with it as a fully functional spreadsheet (filtration, cell formulas, conditional formatting, pivot tables, charts, etc.) in one place.
Hi @eClaireS ,
You’ll be able to use plenty of Excel-like functions inside the Smart Spreadsheet. Here you may find the list of available functions to use.
If you have an already created xlsx/csv file, you’ll be able to import it to monday.com and continue working with your data inside the Smart Spreadsheet.
Hello all, just have dicoverded that if you add a “http://” using the function concatenate on the formula column, monday will automatically add the link to the result of the formula… hope this help you guys, for us it has.