Improve the sync with multiple Google Sheets linked to each other

Hi. I start with a simple illustration.

The BUG view is based on the Data table, which performs two tasks:

  1. Adds A to B which have been entered through the view.
  2. Let another spreadsheet, linked by IMPORTRANGE, do the same and receives the result.

The first result is correct, while the second is the previous sum, when B was equal to 6. Another sync is necessary to update it.

This means that the app does not wait for the full spreadsheet refresh before syncing and therefore shows inconsistent results.

It’s a shame having to tell the user not to forget to sync after every change made, or to camouflage a forced sync in grouped action buttons, among other tricks.

The use of linked spreadsheets is known to avoid loading large files on the platform.