nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Smartsheet Community

Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.

Welcome!

This Post is Archived and Read-Only

The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.

Browse Active Topics

% fields not displaying correctly

Shawn Brandwein

Why do my % fields sometime automaticly round up (4.6% displays as 5%) and sometimes they display correctly (4.6% as 4.6%).

When I average those fields out it is wrong when i have the fields as %.

Here is what I enter into the fields with the % turned off

Mar 30 Apr 3 April 6 Monthly Average

0.048 0.040 .050 .046

Here is what is displayed when I have the % field turned on

Mar 30 Apr 3 April 6 Monthly Average

5% 4% 5% 5%

Obviously there is a big difference in what is being displayed.

monthly Average Formula:

=AVG(April20, [Column3]20, [Column4]20, [Column5]20))

Comments

Kazarenko

Hi,

This looks like a rounding issue. Try formatting the cells that are % by highlighting tham and using the Increase Decimal button (this should be under the % button and looks like 3 zeros and an arrow). Each time you hit the button it will give one extra decimal place in the percentage.