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

  • Michael Culley
    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.

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