Number formatting in Sheet Summary

itsnotbroken

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

Andrée Starå

Hi,

Sounds like you found a bug.

If you haven’t already, I would recommend that you reach out to the Smartsheet Support Team. Smartsheet Support Team

Hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD