Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
Exporting Excel formulas
Alejandro Silva
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??
JamesR
See help on Exporting to Excel: http://help.smartsheet.com/customer/portal/articles/770623
There is a Note about excel Formulae there:
"NOTES:
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.
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?
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!
@Alejandra - has there any movement on this functionality since 2018. I imagine there might be. I am all ears if so!
Anyway we can make this view only for security purposes? We would like to prevent users from sending responses to other users by accident.
I am currently setting up an automation for people to get notified through their email, when they are prompted. But is there a way that they can reply in the email of a comment that will then go to the specific sheet. This way they do not have access to the sheet, but can just comment through email with updates?
I am extremely frustrated and disappointed with my current Smartsheet experience. I have paid for a Pro subscription, I am the owner and administrator of my account and sheets, and I have confirmed I am logged into the correct account. Despite this, Smartsheet is not recognizing my Pro subscription, and I am unable to…
