Cross-Sheet Formula:

Hi,

I would like to ask the community on how the 100,000 inbound cell cross sheet reference is computed.

Using the following example:

If I have a sheet with 10 columns and 100 rows, and 2 column level formulas using index/match cross-references to the same (or different) sheets, then my current inbound cells count is 2 *100=200. Is this correct?

Smartsheet Documentation:

https://help.smartsheet.com/articles/2476606-formulas-reference-data-from-other-sheets

Each sheet can include no more than 100 distinct cross-sheet references.
There’s a limit of 100,000 inbound cells that can be referenced from other sheets into one sheet in total.

Find more posts tagged with

Formulas

Accepted answers

Paul Newcome

That is correct. Are you getting some kind of error?

All comments

Paul Newcome

That is correct. Are you getting some kind of error?

Chris Kaliveas

Hey Paul, thank you heaps for the confirmation. I'm not getting an error. I'm just creating an admin sheet to monitor actuals vs sheet limits. I'm also using one of your range formulas too from another post for total number of columns (first/last) in a sheet and using a baseline (expected value) to monitor changes too.

Paul Newcome

Happy to help. 👍️

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.