Number formatting in Sheet Summary
I'm using sheet summary to get rid of the top row on our master project list. Formerly, we used "=SUM(CHILDREN())" to add up all projects & sub tasks.The top row was only there to add everything up. We moved this function over to the Sheet Summary & it's working fine. My issue is the number formatting. The budget totals are in the millions, and there is no reason to display cents on that huge amount. I right click the summary cell & use "number Formatting" to get rid of the numbers to the right of the decimal. I LOCK THE CELL. Next time the sheet refreshes, or any data is added, the decimals are back.