Running Functions You can run most Smart View functions automatically using Refresh commands. To run functions and retrieve values: Connect to a data source. Open the sheet that contains the functions you want to run. Do one of the following: For HsSetValue, click Submit. To run functions and update all the sheets in the spreadsheet, click Refresh.