Wednesday, October 9, 2019

Goal Seek add-on now available for Google Sheets

Update (October 14, 2019): We previously stated that the Goal Seek add-on would impact the API request quota for your domain — this was incorrect. There will be no impact on API request quotas from using the Goal Seek add-on and we've updated the blog to reflect this correction.

What’s changing

The Goal Seek add-on for Google Sheets can now be downloaded and installed from the G Suite Marketplace.


Populating and triggering the solve functionality for the Goal Seek add-on.

The Goal Seek add-on running and successfully finding a solution.


Who’s impacted

Admins and end users

Why you’d use it

You can use the Goal Seek add-on to calculate the required value of a cell to achieve a desired value in another cell. This is particularly useful when conducting break-even analysis or sensitivity calculations, like determining how changing one value affects other correlated values in your sheet.

How to get started

Helpful links

Availability

Rollout details

G Suite editions
  • Available to all G Suite editions

On/off by default?

Stay up to date with G Suite launches