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
- Admins: If you allow users to install only whitelisted applications from the G Suite Marketplace, you’ll need to whitelist the Goal Seek add-on for your organization. Use this article in our Help Center to learn more.
Helpful links
Availability
Rollout details
- Rapid Release domains: Full rollout (1-3 days for feature visibility) starting on October 1, 2019
- Scheduled Release domains: Full rollout (1-3 days for feature visibility) starting on October 1, 2019
G Suite editions
- Available to all G Suite editions
On/off by default?
- This add-on can be installed from the G Suite Marketplace.
- This feature will be OFF by default and can be enabled at the domain level.