Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

Cross Sheet Reference Maximums

Hello! Does anyone know if cross sheet reference maximums increased since Engage?

I know sheet capacity increased and cell link capacity increased, but I don't recall cross sheet references specifically being called out. As far as I am aware (and is still documented: Smartsheet Help Page), there is a maximum of 100 cross sheet references with a reference range maximum of 100,000 cells.

I do have a sheet right now that is actually looking at closer to 120,000 cells and I am not getting an error message so I am wondering if this capacity has changed.

Thanks!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions