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.
Help Article Resources
Check out the Formula Handbook template!