Helper Column Formulas, Make Them Stay When Moving Sheets

Options

Hi,

I have a sheet that is archived every month to another sheet. However, within that sheet are many helper columns, so the formula always gets erased. What can I do to keep the formulas stay permanently within the sheet? I tried putting a hidden helper column within a form, but I guess it doesn't work that way. It adds a ' to the formula.

Answers