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?
Tags:
Best Answer
-
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?
Answers
-
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?
-
You're right! My formula was referencing the wrong columns. Ha!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 487 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!