Dynamic View $ Formatting

Kim Stephens

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!

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

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,

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