Nesting SUM, Decimal places, and %
I'm attempting to calculate the percentage of work that's done, round it to a whole number, and add a percent sign. I can get 2 of any 3, but not all three.
=SUM(([Points Done]@row / [Total Points]@row) * 100)
Adding + "%" to the end of the equation gives me 5 decimals.
I'd also like to add an IFFERROR for when there are no points. How do I nest all these together?
Best Answer
-
So percentages in Smartsheet are actually calculated as decimals. .1 = 10%, .5 = 50%, .75 = 75%, 1= 100%... if you've set the % row with percentage formatting or are using a predefined row, you should formulate your answer to provide you with a decimal. Did that work? Let us know.
Answers
-
So percentages in Smartsheet are actually calculated as decimals. .1 = 10%, .5 = 50%, .75 = 75%, 1= 100%... if you've set the % row with percentage formatting or are using a predefined row, you should formulate your answer to provide you with a decimal. Did that work? Let us know.
-
Let me ask a different way:
=SUM(([Points Done]@row / [Total Points]@row)) results in .63636
=SUM(([Points Done]@row / [Total Points]@row) * 100) results in 63.636363
=SUM(([Points Done]@row / [Total Points]@row) * 100)+ "%" results in 63.636363%
1) How do I specify no decimals, and have a percent sign?
2) If the Points column is empty, how do I incorporate an IFERROR to have a custom message?
3) Anyway to have this in one equation?
My attempts to combine them haven't worked.
Thank you!
-
Have you tried formatting the column as Percentages using the % option in the toolbar?
Use the first formula that results in .63636 and send me a screenshot of the final result!
-
I completely missed that button! Thank you, it works perfectly.
This IFERROR works now also, thanks for your help.
=IFERROR(SUM([Points Done]@row / [Total Points]@row), "Unpointed")
-
Awesome. Glad I could help. Please mark my answer as best answer if you think it resolved the situation for you. Have a great day!
