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!

Best Answer

  • NicoLHC
    NicoLHC ✭✭✭✭✭
    Answer ✓

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

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

    If my comment helps you, I appreciate a 💡

    Kind regards

    Meet me at Engage in Seattle!

    Nico | LinkedIn

    CEO | Lighthouse Consultings

    Lecturer in Business Information Systems | DHBW

    ________________________________________________________________________________

    addvalue@lighthouseconsultings.com

    We offer Licenses - Training - Solution Engineering

    🔴Certified Smartsheet Partner _______________________________________________

    💯 SCALEABLE Solutions Engineered by Lighthouse Consultings

    We Don’t Just Implement Smartsheet; We Revolutionize How You Manage, Plan, And Execute.

    🎥 YouTube 🚀TimeLine View

    http://lighthouseconsultings.de/

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!