Secure Collaborative Google Sheet Setup

I have a Google Sheet packed with formulas that drives our day-to-day reporting. I’m ready to roll it out to the rest of the team, but I need the sharing settings fine-tuned first.

Here’s what I’m after:

• Every user must be able to use their own filters (or filter views) without affecting anyone else’s view of the data.
• They should only be able to edit one clearly defined column; everything else stays locked.
• All existing formulas—across every sheet—must be fully protected so they can’t be overwritten, even accidentally.

The workbook is already built and functioning well; I simply need the correct combination of protected ranges, permissions, and interface tweaks applied. A brief walkthrough or short Loom showing how you configured it will be the acceptance test.