What Formula to use
Hi everyone,
I'm new to smartsheet and I'm having a hard time seeing how I can add up multiple ratings that contain words and then divide them to get the ratings...
Employee Rating:
3 - Meets Expectations Performance
5 - Significantly Exceeds Expectations
3 - Meets Expectations Performance
5 - Significantly Exceeds Expectations
3 - Meets Expectations Performance
5 - Significantly Exceeds Expectations
Which is 24 and then divided by 6 would be 4 if somehow I could also link it to my rating scale to also include the narrative would be great.
Answers
-
I would suggest a helper column to pull the number into its own cell.
=VALUE(LEFT([Employee Rating]@row))
Then you can average this column and drop the average into a nested IF statement to output the desired text based on the numerical average.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!