search

sajacy / google-sheets-what-if-analysis

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

Allow inputs from different tabs (sheets) #6

Closed brush701 closed 4 years ago

brush701 commented 5 years ago

The existing implementation calls getA1Notation() which strips off the sheet name from the range. By using the response text directly we can support inputs from other tabs in the sheet.