Audit One Field Before It Breaks

The column looked right. Until you looked. RevOps analysts and data stewards know the feeling: a CRM import is two days away, and the tier field has been entered by twelve different people over eighteen months. It should have four values. It has eleven. This template uses column-level @mentions to run a complete data quality audit on any field in seconds. @mention the column, tell Obvious what the valid values should be, and get a Column Audit Report with value distribution, every invalid record classified by issue type, and a remediation list grouped and ready to act on. What's included: Customer Accounts sheet — 25 sample B2B records with an intentionally messy customer_tier field (11 unique values, only 4 are correct) so the audit is immediately interesting Audit Log sheet — tracks every audit you run with counts, issue summaries, and remediation status Audit a Column for Data Quality task — a 5-step guided workflow from @mention to remediation How it works: @mention the column you want to audit Tell Obvious the valid values it should contain Get a complete audit report — distribution, flagged records, issue classification Review the remediation list or apply all fixes in one prompt Who it's for: Data stewards, RevOps analysts, and anyone cleaning CRM or operational data before a migration, import, or report run.