Like with other spreadsheet software, Spreadsheet.com Formulas use cell references that can sometimes require readjustment. Sometimes you create a formula referring to the value in cell A1 but that value moves to a new cell.
Situations that should not require formula readjustment
Most changes to your worksheet should not require a readjustment; Spreadsheet.com will automatically adjust cell references in formulas for you. Specifically, you should not have to adjust your formulas when:
- Inserting or Deleting Rows and Columns
- Changing your View
- Filtering Data
- Sorting Data
- Hiding Columns in your data
- Merging Cells
Situations that may require formula readjustment
- If your formula uses absolute references that move or change.
- Copying or cutting data from one place in a worksheet to another.
- Manually deleting and typing data into a new location.
How to readjust a formula
It is often easiest to readjust the formula in one location, then paste that readjusted formula in all other formula locations.
For instance, in the animation below we first insert a new column, which does not require us to adjust our formulas. But it does move a fixed value from where we want it to appear. So we move this value, adjust a referring formula, and then paste that new formula in all other locations.