Creating Free-Form Grids

You can create a free-form grid by typing dimension and member names directly into cells in a sheet.

To create a free-form grid:

1. Open a new sheet and connect to a data source.

   If you already connected to any data sources on other sheets and want to apply the same connection, open the Active Connections dialog box, select the server URL, and click Set Connection for Sheet. For more information, see the Setting Active Connection for an Existing Sheet section in Setting Active Connection for a Sheet.

2. In the sheet, create a grid by typing the member names in rows and columns in free-form mode.

   Follow the guidelines specified in Guidelines for Working in Free-Form Mode.

3. In the Extensions menu, select Smart View for Google Workspace, and then select Refresh.
4. Select the plan type to which you want to connect and retrieve data for the grid.

   The sheet refreshes and displays the values in the grid.