Formulas with INDEX and MATCH function now showing #NOMATCH

Renee Dillard

All of my columns that are using the INDEX and MATCH function are now showing as #NOMATCH. was there a change made in Smartsheet? what will i have to use now instead?

Paul Newcome

There was no change in Smartsheet regarding the INDEX or MATCH functions. It sounds like something may have been changed with your data. Can you provide some screenshots and the exact formula being used?

Paul Newcome

There was no change in Smartsheet regarding the INDEX or MATCH functions. It sounds like something may have been changed with your data. Can you provide some screenshots and the exact formula being used?

Renee Dillard

You're right! My formula was referencing the wrong columns. Ha!