Flags · one of 98
Technical Errors On Sheet ▲
Small sites metric 1.2.3 · ▲ input error · raised at 5. Area Habitats!J2, 6. Hedges & Lines of Trees!J2, 7. Watercourses!J2
Raised when
The sheet's own error search failed — a formula on the sheet returned an Excel error.
To clear it
Look for #VALUE!, #N/A or #REF! on the sheet. Usually a hand-typed value where a drop-down was expected.
See every flag your metric raised, on one page. Drop the workbook on the Check page and Quadrat gathers each ▲ and ⚠ it wrote, with these notes beside it, plus what a planning officer will ask that the metric never flags.
This is one of 98 flag strings the GOV.UK statutory biodiversity metric 1.0.4 and small sites metric 1.2.3 write into cells. Explained from the workbooks' own formulas; where the statutory metric user guide's troubleshooting table covers a flag, the page says so. Quadrat is not affiliated with Defra, Natural England or any planning authority.