Adjusting Values in Data Cells

You can adjust the value of one or more data cells by a specified number or percentage if the cells contain numerical data.

To adjust values, you can select a single cell or a range of multiple cells, including continuous or discontinuous cell ranges. However, while selecting a range, if you select a read-only cell, a cell with supporting details, a cell with string or non-numeric values, or a cell outside the grid, then relevant error messages inform you that the adjust operation cannot be performed and prompt you to modify your selection.

Note:

Data cannot be adjusted over time periods, as spreading data for time periods is not supported. For example, adjusting data in a Quarterly data cell does not adjust the values in the corresponding Monthly data cells.

To adjust data values:

1. In a form or ad hoc grid, click the data cell that contains the value to adjust.
2. In the Extensions menu, select Smart View for Google Workspace, and then select Form or Ad Hoc.
3. Select Data, Adjust, and then select Adjust.
4. In Adjust Data, select an option and then enter the number or percentage by which you want to adjust the value of the cell.

   Available options are:

   • Add fixed value to selected cell(s)
   • Subtract fixed value from selected cell(s)
   • Multiply selected cell(s) by a fixed value
   • Divide selected cell(s) by a fixed value
   • Increase selected cell(s) by a fixed percentage
   • Decrease selected cell(s) by a fixed percentage
5. Click Adjust Data.