Helper Column Formulas, Make Them Stay When Moving Sheets

JPapa

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.

Andrée Starå

Hi @JPapa

I hope you're well and safe!

You could add the same formula on the other sheet as a column formula.

Would that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!