Number formatting in Sheet Summary

itsnotbroken
itsnotbroken ✭✭✭✭✭✭
edited 12/09/19 in Smartsheet Basics

Hello all,

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.   

Any ideas?

Thanks

8-20-2019 10-35-40 AM.jpg

Comments