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.

Deleting Cell History

Kylie D'Costa
Kylie D'Costa ✭✭
edited 12/09/19 in Archived 2017 Posts

Hi SS Users,

 

So I have been busy setting up a whole lot of sheets, reports and sights - and been testing them extensively before we roll them out to users.

 

As part of this testing, I have been typing in 'testing data comments - and some random made up stuff' into cells to test formulas, linkages, notifications etc etc.

 

Problem is, I now want to use these sheets, but most cells have very strang and random cell history trail.....

 

Is there a way to delete the cell history, so everything starts from scratch?? I did not want to have to rebuild new sheets/reports and sights.

 

Thanks team!

· Share on FacebookShare on Twitter

Comments

  • Mark Weeks
    Mark Weeks Overachievers

    Hi there,

     

    Maybe clear all contents in cells and then save as New sheet?

     

    Kind regards,

     

    Mark.

    · Share on FacebookShare on Twitter
  • Richard Rymill SBP
    Richard Rymill SBP ✭✭✭✭✭✭

    Kyle

    if the sheets you have created and tested are now ready to be used and are connected in a workspace you can Save as New and study the menu list of what you want to keep and what you dont, then you should have what you need? 

    You can do this by Sheet or Folder of connected sheets/ Reports or by Workspace. 

    Hope that helps? 

     

    Richardr

    · Share on FacebookShare on Twitter
  • Kylie D'Costa
    Kylie D'Costa ✭✭
    edited 01/17/17

    Thanks guys - worked a charm!

    · Share on FacebookShare on Twitter
  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭

    Save as Template would also have worked.

     

    Craig

    · Share on FacebookShare on Twitter
  • Dietrich Koch
    Dietrich Koch ✭✭✭✭✭✭
    edited 01/19/17

    Kylie, Richard, Craig,

     

    I have the same problem that cell history is copied when using the "Save as new" feature... So, which of the entries in the menu should not be ticked in order to not copy the cell history (Screenshot in german language)?

     

     

    Dietrich

    Cell-History Smartsheet.png

    · Share on FacebookShare on Twitter
  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭

    Dietrich,

     

    When I use the Save As New feature, the cell history is NOT copied.

    All my checkboxes are checked.

     

    The original post was that she wanted to clean them out and did not realize that Save As New would do that.

    It doesn't for you?

     

    Das ist ganz merkwuerdig.

     

    Craig

     

    · Share on FacebookShare on Twitter
  • D Domine
    D Domine ✭✭✭✭

    We had a team member accidentally put an admin password in a cell.  She didn't realize she did it.  Then the alert went to the team about changes to the sheet.  No one knows it's an admin pw, but we'd like to remove it from the cell history just in case.

    Creating a whole new sheet isn't great for us because we want to keep the cell history of other cells.  Just not this one.

    Any ideas?  TIA

     

    _David

    Houston, TX

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

Categories