API 0:38 video
How to add Goal Seek to an API
Add Goal Seek to a SpreadsheetWeb API endpoint so callers can calculate the input value required to reach a specified formula result.
- Click on "Design".
- Select the "Goal Seek Event" using the "Create" button under the "Events".
- Name the "Goal Seek Event, "then select the "Changing Reference Named Range" and "Target Reference Named Range."
- Set the "Target Value," "Max Iterations," and "Max Change" before creating a "Goal Seek Event."
- Lastly, publish the application.