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

  • KPH
    KPH ✭✭✭✭✭✭

    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!