Subtitle: Data validation, conditional formatting, counts per status, a "stuck" flag, and a check that catches statuses typed by hand Written with AI assistance. I edited it. The formulas below were c
Subtitle: Due dates that skip weekends and holidays, working days left, and a "Remind now" flag with WORKDAY and NETWORKDAYS Written with AI assistance. I edited it. The formulas below were checked in
Total, order count, last order date and "gone quiet" flags per customer with SUMIFS, COUNTIFS and MAXIFS, plus a check that nothing was left out
Commas, currency symbols, hidden spaces, (brackets) and Dr/Cr turned into real numbers, with a check against the statement total
Sales, orders, refunds, running total and month-on-month change from a plain order list, plus a check that catches dates typed as text
TRIM, COUNTIF and a dropdown list: three checks that stop one typo from splitting a customer's totals