Achieving Optimal Index-Match Performance

I'm wondering if anyone has any insight as to whether or not Index-match works any faster when the fields being used in the look-up contain numbers only, instead of text or text/number mix?

In my own anecdotal experience, sheets that use index-match on numbers-only columns do seem to open/update/save faster. But I have no way of knowing is this is true, or a coincidence, or merely my own subjective observation.

BTW, yes, I know that SmartSheet does not offer distinguished/different column types for text vs. numbers; it's all "text/number." I'm talking about structuring your data in such a way that columns involved in index-match happen to contain numbers only, and observing a performance improvement with this set-up compared to an index-match that uses columns containing both text and numbers.

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!