Employee Reviews - Averaging scores for different criterea
Been playing around with a few index/match formulas but getting a bit complicated..🤯
To explain:
- Need to add numeric values to each dropdown to give scores to each critera
- Then search for each Reviewer that reviewed each employee and add all scores for each critera
- Finally, average the score =AVG(CHILDREN())
Went ahead and published both sheets if it helps for more reference.
Thanks for reading!
Answers
-
Hi Maricarmen,
Do you have to follow exactly the Employee Review sheet or can we use a different template ?
If second option, I think using a template similar to Role Review Testing would be easier in your case.
Thanks,
Mathieu | Workflow Consultant
info@evolytion.com
-
Ended up creating a helper colum "Employee+Reviewer" in order to be able to index and match both Employee and Reviewer criterias.
=INDEX($Score$2:$Score$6, MATCH(INDEX({Complete Table}, MATCH($[Primary Column]$8 + " " + [Primary Column]@row, {Help Join}, 0), 3), $[Primary Column]$2:$[Primary Column]$6, 0))
{Complete Table} is from Employee to Criteria 5
{Help Join} is Employee+Reviewer
If anyone has any other idea or optimization, let me know!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!