Google Sheets editing & Formatting

My working file in Google Sheets has started behaving strangely: several formulas no longer calculate, and the conditional formatting rules I once set up have stopped triggering. I need someone who can open the sheet, trace the broken references or syntax errors, restore the calculations, and then make sure the conditional formatting rules fire exactly when they should.

You’ll have view-only access first so you can outline what needs changing. Once we agree, I’ll switch you to edit mode. The goal is a clean, reliable sheet that updates automatically without manual tweaks.

Acceptance criteria:
• All existing formulas return the correct results and no longer show errors.
• Conditional formatting applies to the right ranges with colours and rules functioning as intended.
• No unintended changes to data or structure.

Please let me know your estimated turnaround and a brief note on similar Google Sheets repair work you’ve done.