Formula for more than 100 crosssheet references?
I read that a sheet can include no more than 100 distinct crosssheet references. I'd like to use INDEX/MATCH, but I have more than 100 matches. What are my options? How have others solved for this?
Answers

That limit is for {Cross Sheet References}. There is a much higher limit that I cannot remember off the top of my head for how many cells can be referenced. Your typical INDEX/MATCH only contains two unique cross sheet references which are what count towards the limit you are referring to.

Thanks, Paul! I should have clarified that I'm trying to use crosssheet references in an INDEX/MATCH formula.

I learned from a colleague that "crosssheet references" means something different from what I thought, and I am good.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!