google-sheets-what-if-analysis icon indicating copy to clipboard operation
google-sheets-what-if-analysis copied to clipboard

Multiple data table scripts run in parallel?

Open dinu-dr opened this issue 4 years ago • 2 comments

I have two data tables, each referring to different row and column inputs. The row/column inputs for table 2 change the outputs for table 1 as well, and I think that is creating an error in output, as the script tries to run both data tables simultaneously.

Should be a quick fix to run data tables in series?

dinu-dr avatar Apr 30 '20 09:04 dinu-dr

In fact, I checked it runs only one of the data tables

dinu-dr avatar Apr 30 '20 10:04 dinu-dr

The script will evaluate only a single data table at a time. This is actually a limitation due to how Sheets add-ons work. Could you provide a link to a sample google sheet?

sajacy avatar May 14 '20 22:05 sajacy