One of the Sheets in my workspace keeps losing all of its data


I have 2 sheets currently in one workspace. The first sheet works as expected, it saves my changes when I save. The second sheet, I imported an Excel file to it. I made a couple of changes and saved. When I returned to the sheet it was blank. I did this three times with the same result. If I click into the other workbook and back I have a blank sheet. My column headers and everything are gone. However, if I copy and paste the data into the sheet the data is retained, but I have to manually name the headers.

Is there a trick to getting Smartsheets to retain imported data from Excel?


Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    Importing like that creates a new sheet. Whatever workspace or folder you have open when you go through the menus for importing will be the workspace or folder containing your imports once you refresh your browser.

    If you want to bring data into an already existing sheet (such as updating existing data), you would need to copy/paste, leverage the API, or look into the premium app Data Shuttle.