Is there a limit to the number of automations and number of sheets a report can reference?

Paul Newcome

FYI for anyone looking for a similar resolution...

We ended up restructuring a portion of one of the sheets that is not shown in any of the screenshots so that we could more easily get the various counts needed. The final solution was built by leveraging an Auto-number column that had no special formatting and started with 1 to allow us to take into account only rows that were previously entered (new rows added via Copy Row automation) to essentially get a running total.