I am working on putting performance evaluations into Smartsheet. We have a set of criteria that employees will be rated on, and below is our scoring scale.
Scoring Scale
5 - Exceptional: Consistently exceeds expectations; demonstrates leadership or innovation in this area.
4 - Strong: Frequently exceeds expectations; performs at a high level with minimal oversight.
3 - Meets Expectations: Performs duties reliably and competently; meets role requirements.
2 - Needs Improvement: Occasionally meets expectations but requires support for improvement.
1 - Unsatisfactory: Frequently fails to meet expectations; performance is below acceptable standards.
I kept the drop down options to just numbers (1-5, without the description) so that it would be easy to calculate a total. Leadership prefers the drop down options to display the descriptions as shown above. Is there an easy way for me to calculate total without creating helper columns to extract only the number? As of now, if I use helper columns, it's going to significantly expand my sheet - I have about 30 criteria built into the sheet and I'd love to not have to add 30 columns.
This sheet will have new submissions coming in annually for all employees (as of now, around 100). I'm worried I will end up needing a metrics sheet, but wanted to reach out to Community first to see if anyone has done something similar.
Currently I'm just using a SUM formula for my range of criteria.
Thank you!
