On/Off Switch for Row Auto Formatting

jaredusey

I believe there is a need for an on/off switch for row auto formatting. I understand I can go in and set formatting conditions or make a helper column but why. When there can be a simple on and off switch?

For example: I have created a working budget report with a parent, child, and sub child rows. So a Project Manager can view and control their budgets. I have also added formulas in the Parent rows. So when a PM enters their budget numbers in the sub children rows. The sheet calculates the math and provides the PM's with accurate data to make budget decisions.

However, the issue we are running into is when a PM enters data on a sub child row. The row auto formats to the parent row. Which causes confusion and frustration when using the sheet.

The sheet admin should have access to turn on and off this auto formatting feature.