Viewing and Changing Supporting Details

You can view and change the supporting details added in a cell.

Cells with supporting details can be indicated using cell styles so that they can be easily identified in a grid. To define a background color for cells with supporting details, in Smart View Options, click Formatting, and then click Cell Styles. Expand Data Styles and select Supporting Details to set the color.

To view or change supporting details:

1. In a form or ad hoc grid, select the cells for which to view or add supporting details.

   You can select one cell or a range of contiguous cells in a row or column. The selection cannot include a combination of rows and columns. Select cells that are in the local currency so that you can write to them.

2. In the Extensions menu, select Smart View for Google Workspace, and then select Form or Ad Hoc.
3. Select Data, Cell Actions, and then select Supporting Details.

   The Supporting Details dialog reflects your cell selection.

4. View the details or change the line items or calculations that aggregate the data in the selected cells.

   Note:

   Supporting details must be edited only in the Supporting Details dialog box, and not in the grid. If you try to edit the cells with supporting details in the grid itself, then an error message appears stating "Data entry is not allowed for cells with supporting details".

   In Google Sheets, if you edit a cell containing supporting details in the grid, and submit the cell while in edit mode, the error message is correctly displayed. However, the edited value still gets submitted. This results in a mismatch of values appearing in the grid and in the Supporting Details dialog box. To avoid this erroneous scenario, always edit supporting details value from the Supporting Details dialog box