Avgw based on a criteria
I'd like to apply different weightings based on a staff members role on the staff sheet. I have a weightings sheet that defines the weighting for each task per role.
I can't work out how to write an if statement that says, if the staff role (staff sheet) matches the staff role (weightings sheet), then use this row of weightings.
Would love some assistance
Help Article Resources
Check out the Formula Handbook template!