Advanced Options

Set Advanced Options for administrative and other advanced tasks.

Options in the Advanced tab are global options that apply to the entire current spreadsheet, including new sheets added to the current spreadsheet, and become the default for all existing and new spreadsheets.

The Advanced tab of the Options dialog is always available. You can access the Advanced tab before performing operations, such as performing ad hoc, opening a form, setting the active connection for the sheet, or setting the connection for functions.

To set advanced options:

  1. In the Extensions menu, select Smart View for Google Workspace, and then select Options.
  2. In the Options dialog, select the Advanced tab.
  3. Make selections in the Advanced tab as described in Advanced Options.
  4. Optional: Continue making changes to options in the Data, Members, or Formatting tabs.
  5. Click OK to save the changes.

Advanced Options

Table 5-1 Advanced Options

Option Description
General General
Save Current Options as Default

Select to save your modified option selections in the Data, Member, and Formatting tabs. After saving, your options selections become the default for any new content that you import from a data source.

Note:

Changes made in the Advanced tab automatically become the default settings. You do not need to select the Save Current Options as Default command to save the Advanced options.

Clear Saved Options Clear the options that you have saved as default in the Data, Member, and Formatting tabs.

This action resets the settings back to default Smart View options.

Number of Most Recently Used Items

Enter a number between 1 and 10 to set the number of recently used items you want to view in the Recently Used panel.

This default value set in this field is 5, that is you can view 5 recent items.

If you don't want to see your recent items in the Recently Used panel, set the number as 0.

For more information, see Opening Recently Used Artifacts Quickly.

Logging Logging
Enable diagnostics Select to enable diagnostics.
Enable client logging Select to enable client logging.
Show Log Click to display the Smart View log in a separate window. You can view the log in the window, download it to a file, or clear it.
Clear Storage Click to clear the storage cache. The storage cache includes your connections and options you previously selected on the Advanced tab, as well as on the Data, Members, and Formatting tabs.

After clearing storage, you are disconnected from your current session. You need to connect again to continue working.
User-Defined Function User-Defined Function
Missing Label Specify a value for missing data in user-defined functions.