We use Google Sheets extensively but are looking for a more robust approach.
In Google Sheets we regularly update some values which are, then, used to calculate some other values. The calculation happens across several sheets: say, Table C uses values from Table B which uses values from Table A. It doesn’t work quite the same in Ragic: values do not get dynamically loaded from linked sheets.
My instinct was to make a table report, or a script, – sorry, I’m not familiar with database terms – which will perform all the fetching and calculation upon request, then spit out a table. But I didn’t figure out how to do that.
Another option – use Link & Load Syncing. But it seems to not work when you need to fetch a value that, itself, has to be fetched from a third table.
For your link and loads, if you have selected the option to keep loaded value sync with source, your load fields will update their values once the values on the source field changes. For your case, you should select this option on all the link and load relationships you’ve mentioned.
We are having same issue. It seems that keep loaded value sync with source doesn’t work properly when the source value has been changed/loaded by other sync process. In other words, it seems that sync doesn’t work in cascade, just works at first level.
I’ve just tested applying consecutive link and load relationships on three sheets (sheet 1 linked to sheet 2, sheet 2 linked to sheet 3) and have keep loaded value sync with source enabled on all link and load relationships. In this case, when I manually updated a loaded source field in sheet 3, the respective value was also updated in the loaded field in sheet 1.
Could you all please check if it is working properly? If not, please describe the linking relationships and how was the values modified so I can take a further look.