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
- 66.5K Get Help
- 432 Global Discussions
- 152 Industry Talk
- 494 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 76 Community Job Board
- 504 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 307 Events
- 37 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!