Audit a Google Sheet for errors and broken formulas
Issue log of formula errors, gaps, and mismatches across every tab, with suggested fixes
Open my spreadsheet [sheet link] and audit every tab for errors. Context: [what the sheet is for and what seems wrong, e.g. monthly sales and commissions, totals don't match my records]. Check each tab for: formula errors (#REF!, #DIV/0!, #N/A), formulas that stop partway down a column or reference the wrong range, hardcoded numbers where a formula belongs, blanks in required columns [e.g. rep name, deal amount, commission rate], duplicates, inconsistent formats, and values that disagree across tabs. If I give trusted figures [e.g. Q2 revenue total from my accounting tool], reconcile against them and show the gap. Only edit what my rules allow: [editing rules, e.g. fix broken formulas, leave values alone]. List everything else as a suggested fix. If a cell's intent is unclear, flag it instead of guessing. Hand back a table: tab, cell or range, issue, suggested fix, fixed (yes/no). End with counts per tab and the 5 issues most likely to throw off totals.