Hi everyone,
I have a project tracker document which has a number of columns tracking all sorts of data. I've been using formulas to fill in certain columns such as costs (based on a variety of rules) and turnaround times. However, the sheet is getting into the thousands of rows range and there are probably 50 different columns. It's not a small document. Because of this, the document is rather slow to perform so I'd like to see if I can move the heavy formulas into a helper sheet in order to keep the project tracker more streamlined.
Unfortunately, I'm struggling to figure out how to do this. I'm using a helper sheet to count the number of times a status has occurred for a project, which is working well, but I'm not sure how to copy over either some or all of the columns to a helper sheet, then do the formulas there, and reference those formulas into the original sheet.
Can anyone help me wrap my head around how to do this? Is there a better way to approach this?
I'm already aware of the suggestion to (a) not use so many formulas/automations/formatting which is not an option, (b) split the data into multiple chunks which would be burdensome and (c) potentially look at using a better local browser.
I'm not providing specific details right now, but let me know if that's needed to find a solution.
