Troubleshoot missing data

Your data might be hidden instead of missing. 

Try this to make your data reappear

Turn off all filters

Select the Filter button to turn the filters off.

Unhide all columns 

Right-click any column header and select Unhide All Columns to see if this brings the missing data back into view.

If you only see Hide column in the menu, then no columns are hidden.

Expand all rows

Collapsed parent rows will hide their indented child rows. Select the Column Menu icon in the primary column header, and select Expand All to see if this brings the missing data back into view.

Check the cell history 

If the sheet is shared, someone else may have saved changes to the same cell after you did, overwriting your changes. Right-click the cell and select View Cell History to see if your data is stored in the history. If it is, you can copy and paste it back into the sheet if needed.

Request access 

If a report looks different to you than it does to someone else, some of the source sheets may not have been shared with you. Ask the report's owner to share all of the source sheets with you. Learn more about sharing.

What to do next

If none of these actions reveal missing data, check if you have a backup version of the sheet. 

For information about backups, see Create a backup copy of your Smartsheet data.

If you haven't configured a backup for the item, contact Smartsheet Support. The Support team may be able to provide a snapshot that contains the missing data. In your request, provide the following:

• Date and time the data loss occurred
• Name of the sheet

Contact Smartsheet support

Backups provide a safety net

It’s a good idea to set up a backup process. If you’re on a Business or Enterprise plan, you can schedule recurring weekly backups. All plans can request a one-time sheet or workspace backup.