search

sajacy / google-sheets-what-if-analysis

Replicates the Excel "What-If Analysis" feature, Data Tables.
MIT License
53 stars 7 forks source link

Multiple data table scripts run in parallel? #14

Open dinu-dr opened 4 years ago

dinu-dr commented 4 years ago

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 commented 4 years ago

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

sajacy commented 4 years ago

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?