Do Cross-Sheet References Impact Sheet Load Time?
As my Smartsheet app has gotten more complex I often try to find ways to simplify sheets and speed things up. The new cross-sheet reference capability has me wondering if it would be faster than the existing links when loading a sheet? I don't know exactly what goes on when you load a sheet but the save icon stays dark grey for several seconds typically and you can't edit things until it dims. Does that have anything to do with rechecking links or evaluating formulas? If the latter, does it have to go back to any sheets the cross-sheet references point to to update the calculations? If so, would it take longer to be able to edit a sheet after loading it if I convert a couple thousand incoming links to formulas that use the cross-sheet references? Also, after having some problems with broken links a couple of weeks ago I'm wondering if the cross-sheet references would be more reliable?