Technical Issues with Formulas in Smartsheet

I am currently experiencing significant technical issues with complex formulas in my Smartsheet. The formulas are extensive and connect multiple sheets, each containing over 3000 rows. Unfortunately, I am receiving error messages indicating that the formulas are unable to access all the rows, and I am also encountering notifications that my Smartsheet exceeds the size limitations supported by the program.

I need assistance in resolving these issues so that I can effectively manage my data without running into these limitations. Any guidance on optimizing my formulas or troubleshooting the crashes would be greatly appreciated. Thank you!

Find more posts tagged with

Sheets

Formulas

Support

Solution Center

functionality

Accepted answers

NicoLHC

@AbrinaLL it is forecasted that the limitation will be resolved in the next weeks, month.

It might be an opportunity to check Data Table if you need a Demo contact me.
Maybe there is the possibility to split you data into two sheet and adjust reports?
We should take a look into general data setup and reporting structure

All comments

AbrinaLL

NicoLHC

@AbrinaLL it is forecasted that the limitation will be resolved in the next weeks, month.

It might be an opportunity to check Data Table if you need a Demo contact me.
Maybe there is the possibility to split you data into two sheet and adjust reports?
We should take a look into general data setup and reporting structure

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.