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.


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

  • Smartsheet User 99

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