Number formatting in Sheet Summary

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

Find more posts tagged with

Sheets

Real Estate

Project Management

Comments

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

Sign in to join the conversation!

Quick Links

Trending discussions

Permissions not updating
I was given editing permissions this morning but when I open the sheet it still says I am View Only.
indent for entire cell
Hi I'm trying to make indent for 78 groups, is there a way to make it in one click or I need to do it one by one. see image below, e.g., I want contioue up to B-78, and that takes a lot f time. Any suggestion?
Automation Workflows - Grouped Email
Hello, I’m writing to request assistance regarding automation notification emails in Smartsheet. Issue: I have an automation set up to notify people when I need jobs scheduled. However, instead of sending a separate email for each job/row, Smartsheet combines multiple notifications into a single, grouped email. This makes…