Formula column HYPERLINK()

Hi guys,

Our company Stiltsoft develops the Smart Spreadsheet for monday app - hope it will help you to use Excel-like features right on monday.com platform.

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.

Best regards,
Katerina Kovriga

1 Like

Hey @kkovriga ,
Can you please advise if this will enable us to import addresses to the location column?
Best,
Claire

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.

Best regards,
Katerina Kovriga

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.

Example, a link for whatsapp

CONCATENATE(“http://WA.ME/”,{Teléfono Móvil})

3 Likes

Using CONCATENATE worked for me. The resulting URL is not very pretty, but clicking it does open up a calculated URL.

Hi Rex,

I know you are, like all of us, looking for a native solution, but in the meantime, if you want a complete solution through a 3rd party app, the Advanced Formula Booster handles this without problem as it can write to any column.

Here is the documentation related to the Link column.