Indicator tracker for Google Sheets: how to calculate attainment against target
Oct 04 2026 · Templates
Build a free indicator tracker in Google Sheets that calculates attainment against target, flags off-track rows and feeds donor report tables.
An indicator tracker is a spreadsheet with one row per indicator holding its baseline, target, means of verification and each period's result, with attainment calculated automatically as result divided by target. In Google Sheets, six columns are enough: indicator, baseline, target, means of verification, result and attainment. A conditional formatting rule colours any row below 80% of target so off-track indicators are visible without reading every number. Keep data entry on one tab and reporting on another that references it, so donor tables rebuild themselves each quarter. The tracker is only as good as its means of verification, so every row needs a real source you can actually read.
What is an indicator tracker and what does it do?
An indicator tracker holds one row per indicator and records what you promised, what you have achieved and how you know. It is not a logframe. The logframe sets out the results chain; the tracker follows it period by period.
At any point in the project the tracker should answer three questions: are we on track, where are we off track, and what evidence do we hold for each number.
What columns does an indicator tracker need?
| Column | What goes in it |
|---|---|
| Indicator | The change you are measuring, stated as a number or percentage |
| Baseline | The value before the programme started |
| Target | The value you promised to reach, and by when |
| Means of verification | The register, system or document you will read |
| Result | The value for the current reporting period |
| Attainment | Result divided by target, shown as a percentage |
Six columns is enough for most projects. Add a period column only if you are stacking multiple reporting cycles in one sheet; otherwise keep one sheet per cycle and let the reporting tab pull across them.
How do you calculate attainment against target?
Attainment is result divided by target, formatted as a percentage. If the target is 500 and the result is 375, attainment is 75%.
Two cautions. Indicators where a lower number is better, such as dropout rate or cost per beneficiary, need the calculation reversed. And indicators already expressed as a percentage should be compared directly rather than divided again.
For indicators where lower is better, use target divided by result. Otherwise your best-performing indicator will look like your worst.
How do you flag off-track indicators automatically?
- Select the attainment column.
- Open Format, then Conditional formatting.
- Add a rule: less than 0.8, red background.
- Add a second rule: between 0.8 and 1, amber.
- Add a third rule: greater than or equal to 1, green.
Those thresholds are a convention, not a rule. Agree them with your team and write them into the M&E plan so everyone reads the colours the same way.
Indicator tracker vs logframe vs M&E plan
| Document | What it holds | When it changes |
|---|---|---|
| Logframe | Results chain, indicators, targets, assumptions | Only at a formal revision |
| M&E plan | Who collects what, how often, from where, and who checks it | When roles or tools change |
| Indicator tracker | The period-by-period numbers | Every reporting cycle |
Keeping these three separate stops the tracker drifting into a planning document. If you are building the logframe first, the free template at /blog/logframe-template-google-sheets covers the results chain the tracker will follow.
Checklist: building the tracker in Google Sheets
- One row per indicator, never one row per result.
- Baseline and target stored as numbers, not text.
- A named means of verification for every row.
- A calculated attainment column, not a typed one.
- Conditional formatting applied to attainment.
- Data entry and reporting kept on separate tabs.
- A frozen header row and a filter view for each donor.
- A short note on the sheet explaining the colour thresholds.
How do you turn the tracker into donor report tables?
Keep a second tab that references the data tab. Use a pivot table or a QUERY formula to pull results by indicator and period, then lay them out in the order the donor's template expects.
Because the reporting tab only reads from the data tab, the quarterly report becomes a copy-paste rather than a rebuild. If you are writing the narrative around it, an evaluation plan keeps the reporting logic consistent across periods, and /store/evalplan covers that structure.
What makes an indicator tracker fail?
- No means of verification, so no result can be checked.
- Targets entered as text, so nothing calculates.
- Results typed straight into the report tab, breaking the link to the data.
- Indicators whose definition changes mid-project.
- One tab shared by five people with no filter views.
Where does the tracker fit in your wider M&E system?
The tracker is one part of three. The logframe sets the results chain, the M&E plan sets the collection routine, and the tracker holds the numbers. If you are choosing tools to sit alongside it, /tools and /which-ai cover the wider set, and /store/indicator has a ready-built version of the sheet described here.
Written for M&E professionals. Not a guarantee of accuracy — always verify every claim against its source, and let a named human sign off. Get the free handbook.