Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Formulas Lost with Data Connector

Jennifer Dewhurst
Jennifer Dewhurst ✭✭✭
edited 12/09/19 in Archived 2016 Posts

I have used the data connector tool to export information from Smartsheet into Excel.  While the information comes over correctly, all of my formulas get wiped out when I refresh the data.  Is there a fix for this?

 

Any help is greatly appreciated.  Thank you.

· Share on FacebookShare on Twitter

Comments

  • Jerry Vieira
    Jerry Vieira ✭
    edited 08/29/16

    You might consider creating a duplicate dummy sheet with no formulas for loading the smartshett values into. Then changing the original sheet to read the values from the newly loaded sheet.  It's a bit clumsy but depending on how complex you excel sheet is, it might do the trick.

     

    Jerry Vieira, CMC

    · Share on FacebookShare on Twitter
This discussion has been closed.

Categories