Calculate formulas by Columns
I am relatively new to Smartsheet and am stumped on a formula, and so are my coworkers. I do QA for multiple teams and I need to be able to calculate information such as # of Exceptional scores (100%), Meets Expectations (85% - 99%), and Needs Improvement (0 - 84%). We tried Countifs, Averageif, and a few others and did not get results. I can't remember which formula we used for a row but it generated a 0 in the column. When inputting data as a test, it remained at 0. If I can't get this formula figured out, I will need to manually count each criterion across the board per team monthly which will really cut into my evaluation process considering I have well over 100 agents that need to be evaluated on a monthly basis.
any help would be super appreciated!
Help Article Resources
Check out the Formula Handbook template!