nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

Exporting to Excel - Question at the end of the discussion

suzybrown76

Exporting Excel formulas

Alejandro Silva

June 11, 2015 4:28 pm

I noticed that formulas, even simple formulas are not exported to a Excel. I have a big smartsheet where we created butcket that has additions per row (summarized) and we noticed that they're not exported as formulas in Excel. It's a shame because we have to start over in Excel an create template and data again.

Is there any workaround to export formulas to Excel??

Comments

JamesR

June 12, 2015 7:01 am

See help on Exporting to Excel: http://help.smartsheet.com/customer/portal/articles/770623

There is a Note about excel Formulae there:

"NOTES:

Because Excel doesn’t support a Gantt chart format, exporting a Gantt chart to Excel will only export the task list. Excel also does not support certain column types (drop down lists, contact lists, harvey balls, check box, etc), so exporting these will only preserve the text values entered into the column.
Due to the differences between Excel and Smartsheet formula syntax, formulas are also not preserved on export. Instead, store them as text by removing the equals sign and saving the sheet. Once you open the Excel file, you can add the equals sign back and modify the syntax to make the formula appropriate for that program."

May not be practical on Larger sheets. Couls double up on Columns with Calculations in and place the calculation in it as text and hide it till you need to export then in excel go to the column and use find and replace to put an equal sign into it. You would then also have the Expected result in the other column as a Check value.

suzybrown76

November 13, 2018 2:33 pm

In reply to See help on Exporting to by JamesR

When I tried to do it, the column name is still the heading, so I don’t see how that can translate into A-Z columns. Does anyone know how to get the export to Excel to work for formulas?

Find more posts tagged with

Comments

Alejandra

Hi,

When exporting a sheet with formulas to Excel, the formulas can be preserved by removing the equal sign —which stores the formula as text. To get the formulas to work in Excel, you’ll want to change the column and cell references to match the column names and cells in Excel.

I hope this helps!

ghurv

@Alejandra - has there any movement on this functionality since 2018. I imagine there might be. I am all ears if so!

Sign in to join the conversation!

Quick Links

Trending discussions

"Fields marked with an asterisk (*) are required." line on every form.
Hi, "Fields marked with an asterisk (*) are required." is the very first line in the body of every form I create. I don't remember seeing it before (unless you missed filling out a required field; then you would see the message). Is there a way to turn it off or change it? None of my forms are in English so the message is…
Best Way to Create a Stacked Bar Chart from multiple columns
I have a sheet that I pull into a report. The report I then want to use to make a stacked bar chart and put into a dashboard if I can. The columns I am trying to make into a stacked chart are: Lead, project and phase. The issue is that there are several leads and I need the stacked bar chart to show in different colors for…
Dynamic View Issue - Group Sharing
I have a dynamic view setup for a dashboard that has NO restrictions And on the Sharing tab, I have a Group that I created as the additional share access to the view But the individuals in the Group still cannot see the data from the dashboard. Am I missing something? Because when I share the view to them individually…