Formulas and Functions
Formulas and Functions
Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.
Keeping Formulas When Downloading to Excel
Hello,
I found online that it says when you download a sheet into an Excel sheet that it does not keep the formulas as they are different.
Now just in case, I thought I'd ask: Is there a work around for this at all? Is there absolutely no way to keep your formulas when you transfer them to an Excel?
Comments
-
Hi Julie
Out of Smartsheet as is, no there is not. However we have developed a number of API solutions for Smartsheet and two of these combined should solve all your needs and then some.
Smarter Formula Loader details here...
Smarter Excel Integration details here...
Both are part of the Smarter Mini Control Center range of Api solutions developed by us at SBP. Happy to discuss and provide a demo for you FOC.
Richardr@smarterbusinessprocesses.com
-
When I need to maintain formulas, I use the following workaround:
I create an additional row at the top of the sheet. I enter all of my formulas in this row but I add in an exclamation point to the beginning of each one. This turns the formula into a text string.
If I need the formulas to continue running in Excel (which isn't always possible because of different functions and different syntax for similar functions), I will use the find/replace to swap out all occurrences of != with =.
This will then convert the text strings back to formulas. The same can be done when importing to SS from excel.
-
It is incredible that they do not have a way to included this as part of the paid subscription. We have to do all the work arounds to get basic things? wow
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.9K Get Help
- 441 Global Discussions
- 153 Industry Talk
- 500 Announcements
- 5.4K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 78 Community Job Board
- 511 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 308 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!
Trending in Formulas and Functions
- I'm curious for some inspiration please! I'm using a form to log usage of machinery. This collects data on the time used in minutes, which I convert to hours and total for each machine. The machines n…
- I am trying to count the number of times "N/A" is included in a single row. I know it can been done with a single range with the below equation, but in this sheet there are some columns that want to e…
- Hello! Long time listener, first time caller — We have a weekly update dashboard that is presented on Thursdays. We'd like to have the date displayed be either the previous weeks Thursday or the curre…