Dynamic View $ Formatting

We have a sheet with multiple columns of dollars, formatted with no decimals for ease of reading. However, the dynamic view directly from the sheet is inserting decimals, which changes the value of the $ and does not accurately reflect what we are reporting. Is there any way to maintain the cell formatting that from the sheet to the dynamic view?

This is what is should be, with the dollar amounts reflecting thousands as it appears in our main sheet.

And this is what we get in the dynamic view, with the decimal

Any help would be appreciated!

Find more posts tagged with

Accepted answers

Georgie

Hi @Kim Stephens,

Thank you for bringing this to our attention! We've determined that decimal places being automatically added in Dynamic View is caused by a bug and our Product team is working on a resolution. We are not able to provide a time-frame on how long the resolution could take but we are doing our best in order to have this fixed as soon as possible.

Thanks,

Georgie

Hi @Kim Stephens,

Having tested this again today, it looks like the issue has been resolved - is this working for you now?

Thanks,

Georgie

All comments

John_Foster

Hi @Kim Stephens,

I had a similar issue with Dynamic View and created a new column that was displayed in dynamic view that had a ROUND formula in place so that the values always displayed as they would in the sheet view.

Sorry it is not a more simple solution, but it was the only way that we could get it to work.

John

Georgie

Hi @Kim Stephens,

Thanks,

Georgie

Hi @Kim Stephens,

Having tested this again today, it looks like the issue has been resolved - is this working for you now?

Thanks,

Georgie

Kim Stephens

Hi @Georgie ,

Just tested and the issue is resolved! Thank you so much for getting this resolved!

Thanks,

Kim Stephens

Georgie

Hi @Kim Stephens,

That's great, thanks for confirming it's working for you!

Georgie

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.