Percent column adds two zeros

noshiro · 01/19/25

I have data that is sync'd with another smartsheet that i cannot manipulate. My percent column when I select "%" format, adds two zeros. Instead of 95%, it shows 9500%. How can I correct this within my own sheet so that my calculations are correct. For now in my total column, I've divided by 100, but wondering if there is another way to do it.

Melissa Yamada · 01/20/25

Hello @noshiro

Format first your % complete column to percentage.

Then add your calculations. For example: =[Column 1]@row / [Column 2]@row

If you're manually adding data on the % complete column, note that percentage in Smartsheet is:

1 = 100%, 0.95 = 95%, and so on…

Melissa Yamada · 01/20/25

Hello @noshiro

Format first your % complete column to percentage.

Then add your calculations. For example: =[Column 1]@row / [Column 2]@row

If you're manually adding data on the % complete column, note that percentage in Smartsheet is:

1 = 100%, 0.95 = 95%, and so on…

noshiro · 01/23/25

@Melissa Yamada Thank you. I found out the data source does not sync to smartsheet as a % and when I format it as a % it adds on the zeros. I have another column that does sycn as a %. What I've had to do is create a formula to divide by 100 on the non-% column, then calculate as needed. It works, but just cumbersome. Thank you for your help Melissa! Have a great day!

Smartsheet Basics

Smartsheet Basics

Percent column adds two zeros

Best Answer

Answers

Quick Links

Categories

Trending in Smartsheet Basics

Link Report in Form

Displaying report summary data in a Dashboard chart widget

Square Radio Buttons?