Is there a way to convert the content of cells obtained through formulas to static content?
At the end of every fiscal year, I'd like to be able to create a sort of "Snapshot in time" from some of my sheets. Also some of these sheets are feeding dashboards and I'd like to "archive" the dashboards as well. The ideal solution would be if there is a way to almost "shut off" the formulas in a sheet but keep the content.
I'm basically looking for a solution to take, say, a sheet and a dashboard with 2020 content and have it freeze content at 12/31/20.
Help Article Resources
Check out the Formula Handbook template!