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.
