Count Formula to total percentage
I'm trying to get the overall total of percentage on all % of Project Done but it's working (77%)
I'm using the count functionality as it's not working when I use AVG.
Count formula I'm using. Overall total when i use microsoft spreadsheet is 144%:
=COUNT([% of Project Done]3:[% of Project Done]122) / 145
Best Answer
-
Thank you so much! it works now! Life Saver!
Answers
-
Try changing up your IF formula a bit.
Smartsheet reads percentages as decimals of 1.
100% = 1
50% = 0.5
1.5% = 0.015
Try replacing your percentages following the above (don't use quotes). Then you can format the column as percentages (may need to adjust how many decimals are shown) and then you can use your AVG function.
-
Thank you so much! it works now! Life Saver!
-
Happy to help! 👍️
Help Article Resources
Categories
Check out the Formula Handbook template!