Supervise, train, or mentor junior team members.

I need the new hire, Jasmine, to stop breaking formulas when she copies rows. Before I send her a list of changes, check the July invoices workbook for relative references that will break on copy, and convert those to absolute where needed. Make sure the totals on the Payments sheet still match the AP ledger and flag any cells now showing #REF or #VALUE. Do this by Thursday morning so I can review before our 10:00 coaching session.

Before I sit down with Jasmine to review her work, make the workbook easy for her to learn from: put a short checklist at the top of the Payments sheet showing which ranges must be fixed before copying, highlight cells she commonly edits, and add a one-line note explaining why to never delete the hidden validation on Column H. Also produce two example fixes I can walk through in five minutes.

I just watched Jasmine copy down a block and the monthly total dropped by $7,250. I’m the accounting lead and she’s defensive; I can’t tell if she misunderstood anchoring or if the template itself was wrong. What is the most likely cause, and what exact three-step fix should I run now so I can show her the repair and prevent it recurring?

Across three hires in the last year we keep losing time repairing broken formulas after they duplicate rows. Each fix costs an hour and erodes trust with operations. What single habit should I change in our onboarding and one concrete audit step to stop this recurring mistake, so new hires arrive able to copy without breaking the ledger?