Formulas Lost with Data Connector

Jennifer Dewhurst

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.

Jerry Vieira

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