Sign in to join the conversation:
I submitted a ticket yesterday afternoon in the portal and it still hasn't been addressed/actioned. What are typical ticket response times?
Hi @JamieM
I would recommend checking your plan type and if you have access to a Support Package that includes phone support. Here's more information: Overview of Smartsheet support hours and resources
In the meantime, is there anything that the Community can help you with?
Cheers,
Genevieve
Thanks @Genevieve P. , unfortunately our plan does not have phone support. I've submitted a sheet restore request so I don't think there's a lot of community problem-solving that will help resolve this issue. Any insight into typical response times for tickets would be helpful though!
Thanks for the context!
While you wait, if you need data from a previous version of your sheet and you're licensed on a Business or Enterprise plan, you can get an excel file of your data from a specific point in time by downloading a "Sheet Snapshot" from the Activity Log. Here's more information:
I hope that helps 🙂
Thanks Genevieve, I did download a snapshot but unfortunately that doesn't restore the lost cell references (I pulled the formulas from the activity log already). Will keep waiting
Unfortunately Support won't be able to help with restoring cell-links if rows or data was deleted; these will need to be added back in manually.
Sheet Snapshots provide you with an excel file with the data from a specific point in time, as you've found. This is the same type of file that Support can email the sheet owner. The only additional data that Support can gain access to is attachments: they may be able to help you retrieve any attachments associated with deleted rows.
However there isn't currently a way to "revert" to a previous version of Smartsheet within the application itself, maintaining formulas and cell links, if that's what you're looking for.
To let the Product team about your scenario, please add your vote and voice to this Product Idea thread:
Hi Genevieve,
Yes, I was looking for the ability to revert to a previous version. Thanks for the clarification, will start the rebuild and add another piece of feedback to that thread.
Hello, I'm working through the writing formulas optional activity and in the 'Nested IF function - Progress Column' task it directs you to put in the following formula '=IF([% Complete]@row = 0, “Empty”)'. However, when I put this formula into the spreadsheet, '04a_Marketing Request Tracker - Formulas', I get an…
I have an automation that has a condition where I am looking at the column "LEA Interco Supporting Site(s)" and trying to find columns that have the value "Fort Loramie" in them. This works well when "Fort Loramie" is the first item listed in the cell, but it doesn't work when "Fort Loramie" is the second or third value in…
Have any of you created a Smartsheet that would show the savings for a project by the month? In other words, if I saved $1200 annually and the project ended in say March, then the savings would go $120 per month, Mar 2025-Feb 2026. I have done it on Excel sheets manually, but I think there should be a way to do it with…
