How to Step Rounding Percentage
Below is a very basic formula actual/workset a to get the %achieved.
You can see that the two calculations are off one should be 33%, the other 20%
What is the best way to show the actual value, not the rounded value?
Thanks!
Best Answer

Ah! I figured it out. It was essentially a doublerounding error.
The formula in Workset A column was 22*0.25, now it's =rounddown(22*0.25)
Then when I apply the formula to the %Achieved column (actual/workset A) it's now accurate. Now I know I need to be more conscious about formulas when there are shared components.
Thanks pointing me in the right direction.
Answers

In your sheet toolbar, look for the highlighted icon below.

Thanks — I already tried that — it only adds decimal places. It doesn't correct the formula result.
This is the simple formula I'm using: =IFERROR(Actual@row / [%Achieved]4, "")

Im assuming that the formula
=IFERROR(Actual@row / [%Achieved]4, "")
is in column Workset A, and you want to correct %Achieved column.What is your formula for the %Achieved column to show that it is 36% and 21%?
If formula for %Achieved is what you are looking for, I think should be
=IFERROR(Actual@row / [Workset A]@row, "")
...

Ah! I figured it out. It was essentially a doublerounding error.
The formula in Workset A column was 22*0.25, now it's =rounddown(22*0.25)
Then when I apply the formula to the %Achieved column (actual/workset A) it's now accurate. Now I know I need to be more conscious about formulas when there are shared components.
Thanks pointing me in the right direction.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.2K Get Help
 320 Global Discussions
 197 Industry Talk
 415 Announcements
 4.2K Ideas & Feature Requests
 126 Brandfolder
 153 Just for fun
 123 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 276 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!