Skip to content

Stockertim Dictionary · Technology · Artificial intelligence

Formula change log

Also called formula change logs, formula log, workbook change log

In short

A simple record of each change made to a workbook's formulas, saying what changed, where, why, whether AI drafted it and who checked it.

  • Beginner
  • Document
  • Checked

In detail

A formula change log is usually a separate tab in the workbook, one row per change. Typical columns are the date, the sheet and cell or range, the old formula, the new formula, the reason, whether an AI assistant drafted or edited it, how it was tested and who reviewed it. The FORMULATEXT function can show a formula as text, which makes copying the before and after versions into the log easy.

The log answers questions that come up long after the change. When a total moves unexpectedly, it shows which formulas changed and when. When a reviewer asks how a figure is calculated, it points to the reasoning. When an error is found, it shows whether other workbooks received the same change. Built-in version history records that a file changed, but rarely why, and not whether anyone tested it.

Recording AI involvement has become part of good practice. A column noting that a formula was drafted with an assistant, with the test that confirmed it, lets reviewers focus their checking and gives managers a view of where AI is used in important spreadsheets. It also fits wider policies that ask staff to record AI use in work that others rely on.

A log only helps if it is kept up. A one-line entry at the time of the change takes seconds; reconstructing changes weeks later is guesswork. Workbooks that feed pay, invoices, accounts or regulatory returns benefit most.

Worked example

An analyst at a housing association in Hull changes the late-fee formula in the Arrears sheet.

  1. Old: =IF(D2>30,25,0); new: =IF(D2>=30,25,0)
  2. Reason: policy charges the fee from day 30; drafted with an AI assistant; tested on 29, 30 and 31 days; reviewed by the finance manager

Anyone opening the workbook can see what changed, why, and how it was checked.

In practice

Finance, payroll and analysis teams keep a change log tab in workbooks that others rely on, and auditors and reviewers read it first when examining a model.

Watch out

  • Version history alone does not record the reason or the test.
  • Entries written long after the change are unreliable; log at the time.

Learn it properly

Official sources

Facts last checked on 9 November 2026.

Education, not advice: the Stockertim Dictionary explains what terms mean. It never recommends buying or selling anything.

English