I have a budget spreadsheet for 2023. It has protected ranges. The permissions are set so that myself and my manager can make edits to all of the protected ranges (I did this through setting a custom permission on the protected ranges). I want to copy the entire spreadsheet so that I can make a 2024 budget spreadsheet. When I do this, it saves the protected ranges, but leaves my manager off. Is there a way to duplicate the entire spreadsheet and keep protected ranges if they are a custom permission?
As I mentioned, I tried copying the spreadsheet and it kept the protected ranges, but it removed my manager. I want it to keep both of us as editors to protected ranges. Any help would be amazing!