How can I format the sheet summary "sum" number?

I have a very simple sheet that has a column of numbers.

Using a Sheet Summary formula such as =sum([column1]:[column1])

I get an answer, but it loses the number formatting - specifically the thousand commas. Since these are pretty big numbers, I need the commas to appear. They appear on the base sheet for the individual numbers, but are lost in the summary formula.

Any suggestions on how to get that sheet number formatting to carry over into the summary formula?

Find more posts tagged with

Accepted answers

Paul Newcome

If you click on the three vertical dots to the right of the field name, you should see an option there for Number Formatting.

All comments

Paul Newcome

If you click on the three vertical dots to the right of the field name, you should see an option there for Number Formatting.

Stephen_at_ODOC

Thank you! That's why I hate buttons that don't appear unless you hover over where they are. Just looking at the screen, there are no "three dots", but once you hover the mouse there, they appear.

Paul Newcome

Happy to help. 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.