Underlying sheet not updating
Does anyone know why my index/match formulas won't automatically update if tied to another sheet? Is this just a Smartsheet thing or am I doing something wrong?
Ex.) I updated someone's information on Sheet 2, but Sheet 1 won't update anything unless I go in and give it a few seconds for the formula to run.
Answers
-
That shouldn't happen and I've also had that experience a few times. The options you can try are A) renaming the reference to something else or creating a whole new reference B) Contact support.
So if you're referencing {ThisColumnonThisSheet} change it to {Newnameblahblah}.
Also make sure you are giving the references unique names and not using the default smartsheet chosen name. I've found that it can cause issues.
-
I'll try that. Thank you for the suggestions.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives