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.
Additional details
This add-on is developed in Apps Script and requires making requests via the Sheets API. That means that the API request quota for your domain will be affected and the number of requests that can be made by other App Script projects could be limited. See the Help Center for more information about monitoring API quotas and adjusting the request quota for your domain.
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.