How to Reverse an Automated Task
Hello, I recently created an inventory tracking sheet and programmed it move a fully consumed material to a separate sheet. The parameter was "If rows are added or changed" when "fully consumed" is checked, then move row to "fully consumed" sheet. It was taking a long time to respond so I manually ran the automated task but then my whole spreadsheet disappeared. They are all now in the Fully consumed spreadsheet. But the problem is, the formulas in the cells are gone and I can now only see the values of the items. Not all information is lost but some of the formulas did take a while to write.
Is there any way to reverse this automated task?
Answers
-
Sadly backups don't include formulas. However, you may still have the formula in the original sheet (definitely if you used column formula). If so, you can delete the columns that should be formulas from the "fully consumed" sheet and use an automation to move the rows back into the original sheet. The formulas will then be used again. Worth trying it with one row. Good luck 🤞
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!