Underlying sheet not updating

Smartsheet User 99

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.

Michael Culley

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.

Smartsheet User 99

I'll try that. Thank you for the suggestions.