Count Formula to total percentage

Virtual Assistant

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

Virtual Assistant

Thank you so much! it works now! Life Saver!

Paul Newcome

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.

Virtual Assistant

Thank you so much! it works now! Life Saver!

Paul Newcome

Happy to help! 👍️