Count How Many between Percentages


I have a list of documents that are being reviewed. People have to indicate what percentage they have completed. So if someone could be 20% done, someone else could be 30%, then another is 50%, etc.

I want to be able to count how many are 0% done, 1 - 30%, 31 - 50%, 51 - 75%, 76 - 99%, and 100%. Is there a way to do this?

Thank you,




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!