Is there a limit to the number of automations and number of sheets a report can reference?
I am looking for options where I am hitting a sheet limit for cross reference formulas. I may need to export to separate sheets, I would be using a copy rows automation, but if I go this route, it would require 209 separate automations. This is very large and I'd rather not go to time or the trouble of just creating them and hitting a block.
I would then need to pull the information back into a report to pull it together in the proper format.
Anyone know of the limits? I'm not seeing anything online.