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?
