Advanced Stuff 0:52 video

How to create goal seek event

Create a Goal Seek event in SpreadsheetWeb to find the input value that makes a selected workbook formula reach a specified target result.

To create goal seek event;

  • Go to the Designer Interface,
  • Go to 'Goal Seek Event Page',
  • Click on 'Add Goal Seek Event',
  • Enter a Name,
  • Choose Target Reference Named Range', 'Changing Reference Named Range',
  • Enter a Target Value
  • Click on 'Add Goal Seek Event'
  • Go to User Interface module,
  • Click on the action button and Add 'Goal Seek Event' event to it.
  • Finally, publish your application.