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.

Release 2016-08-06 unintended consequences (part 2)

J. Craig Williams
J. Craig Williams ✭✭✭✭✭✭
edited 12/09/19 in Archived 2016 Posts

I noticed that many of my sheets were "updated" on Aug 7th.

Many more than is possible or likely.

 

But not all.

So something triggered the update. Perhaps associated with the new formulas.

 

Normally, I likely woudn't even notice this, but I'm in the middle of working with two clients that have far too many sheets and they aren't sure exactly what they have ... and we are in the middle of determing what sheets are being used and which likely not so this is a significant inconvenience.

 

I doubt there is a way to get a sheet access report from last week or something like that ... but any help would be appreciated.

 

Craig

 

Comments

  • Tim Meeks
    Tim Meeks ✭✭✭✭✭✭

    i had one uses tha thad some SUM formulas and reference formulas wiped out. 

     

    Then another fomula was in the wrong column. She corrected before I could send examples over.  

     

    Going to get users to check all sheets with formulas to verify no issues.

     

    Tim

  • Those updates were triggered by the new calculation engine and are a result of the new calc strategy & increased precision.  Any change made as a result of the migration will be performed by the user "[email protected]" so you could potentially use that info to filter out the rows modified by migration, though it sounds like you're after the date of the modification before the last?  We've gone through and migrated sheets in chronological order, so things that have been migrated have been accessed most recently.  That means that a reasonable first-pass on "active sheets" for your client is those that have been migrated.  We will keep going on the migration, though, so grab a snapshot soon, then again in a bit, and you'll get some checkpoints on what's used most recently. 

     

    Cheers,

    Erik

  • @tim

     

    Sorry to hear about the range issues and they're very unexpected.  If you can point us to an example, we'd be very interested and will work to figure out what's happened. 

     

    Thanks,

    Erik

This discussion has been closed.