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.
Using CONCATENATE worked for me. The resulting URL is not very pretty, but clicking it does open up a calculated URL.
GCavin
(Gilles Cavin - Reinventing Formulas in monday.com)
26
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.