Function Keeps Breaking
Hello - I am doing the INDEX + Match functions and it works for a day or two then it breaks again. Am I doing something wrong?
I am the owner of the current sheet and pulling data from a sheet that I do not own but I am the admin on.
Answers
-
Hi @Sarah Underwood ,
Is someone else making changes to the base sheet that impact your data ranges? From within your formula highlight a portion of the range until you see the option "Edit Reference" and click it. Is it the right range? Not sure what else could be going on.
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
-
Hi @Mark Cronk - when I update it the range is correct. But yes, it is being updated on the other sheet and my plan is to pull all the updated data through to my sheet. So when the data is updated on the other sheet the function no longer works.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.3K Get Help
- 392 Global Discussions
- 214 Industry Talk
- 447 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 292 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!