Need advice: Averaging subitem scores into main item and auto-assigning weekly status
Hi everyone,
I’m looking for advice on the best way to set this up in monday.com Work Management.
I have a board where we track new hire evaluations during their first 6 weeks of training. Each week is set up as a main item, and each day of that week is set up as a subitem. The subitems represent the days that the new hire is on the counter processing transactions with customers.
Our trainers go into the subitems and assign status labels across several evaluation columns for each day. I then have a formula column on the subitem level that calculates a total score for that day.
What I’m trying to do now is calculate an average for the entire week on the main item based on the daily subitem totals. After that, I’d like the main item to automatically assign an overall weekly status label based on that average, such as whether the trainee is doing well, needs improvement, etc.
Has anyone set up something similar?