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!
-
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.4K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 492 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 76 Community Job Board
- 504 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 307 Events
- 37 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!