The idea1 / 13
What are we solving today?
A formula links its result to source cells instead of storing a fixed answer, so the result changes when the data changes. A relative reference adapts when a formula is copied, while an absolute reference preserves the location of a shared setting such as a completion threshold.
After this stop…
Calculate completion rates and differences, total quantities, and apply a clear condition with a fixed reference whose value can change without rewriting formulas.