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.

Find more posts tagged with

Accepted answers

All comments

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.