Links to cells of other worksheets take time to be updated

I have run into the following situation multiple times:

I have cells on a worksheet (let's call it "destination sheet") that has links to cells on another worksheet ("calculation sheet"). Cells on calculation sheet are formulas aggregating some cells on another sheet ("source sheet"). After the source sheet is updated, the calculation sheet recalculates immediately, however, the links on the destination sheet to the calculation sheet won't update the final result on the destination sheet immediately. It takes some hours to update the result. I am not sure how many hours it takes, in some occasions, it is 5 hours, in some other occasions it takes a couple of days.

Has anybody run into this situation before too? What is the issue here?



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!