Auto-update formulas when pasted into new column

Francisco

Similar to excel.. it would be great to have variable cell references so that formulas could be copied to a new column. Currently, we have to manually click into the formula to make adjustments so that reference cells are updated. e.g., if I have a formula in column 3 that points to column 2, but need to copy the formula into column 5 to point to column 4, I need to do that manually...