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

Replicates the Excel "What-If Analysis" feature, Data Tables.

Results 17 google-sheets-what-if-analysis issues
Sort by recently updated
recently updated
newest added

Hi,great plugin! I understand that it's problematic to have immediate refresh to the output. But I think totally manual is also very tedious. I suggest to allow automatic refresh once...

This started as a hastily written script, then became a fun experiment with how to publish an extension. There have been recent improvements (contributed by you fine Internet folks!), and...

So I have to manually delete the named ranges before recreating the data tables. I think this is due to [line 142 in WhatIfAnalysis.gs](https://github.com/sajacy/google-sheets-what-if-analysis/blob/452247091a5e359f1a6d39e22cc4a9f56f130b67/WhatIfAnalysis.gs#L142) looking for the index of a...

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...

![print_error](https://github.com/sajacy/google-sheets-what-if-analysis/assets/16750913/1c3fb140-5568-468c-a78c-52a945f3ef70)

This app tried to access sensitive info in your Google Account. To keep your account safe, Google blocked this access. This is the message i get

Error attempting to use the app: "This app is blocked This app tried to access sensitive info in your Google Account. To keep your account safe, Google blocked this access."