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?

Find more posts tagged with

Construction

Formulas

Project Management

Importing and Exporting

Comments

Richard Rymill SBP

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

Paul Newcome

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.

Rbait

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

Sign in to join the conversation!

Quick Links

Trending discussions

Dynamic formula to return date of next Thursday every week.
I'm wondering if anyone has worked out a dynamic formula to return the date of the 'next' Thursday of the month. I have a worksheet where I need to send out a reminder to a contacts in a contact column in the worksheet each Thursday of the current month if a criteria has not been met. When criteria has been met, then…
Check box for date in previous month
Hello, I have the formula to check a box for line items with the current month. =IF(AND(YEAR(Date@row ) = YEAR(TODAY()), MONTH(Date@row ) = MONTH(TODAY())), 1, 0) Trying to set up a report for all items with the previous month (i.e. 1 month prior to current). How can I modify to check the box?
Need Help with If, Index, Collect
Please help, I have a few of these to do. I have a nested IF formula. The first part is an INDEX/MATCH and works as a standalone. The next few are INDEX/COLLECT. These are not working as standalone or in the nested version (Unparsable Error). Any ideas? =IF(CONTAINS(“A/V”, [Vendor Type]@row ), INDEX(COLLECT({Date Secured…