Is it possible to use a multi-select cell as the criterion for a COUNTIF formula?
I have one sheet with training items for different positions (All, BD, CTL, etc.) As these items are trained they are marked as "Complete" from a list of "Not Started" "In Progress" "Complete". I have a separate sheet that I would like to use to track training progress for the employee.
It gets complicated because an employee can be trained on multiple positions. So I would like the formula to count an item if it is marked complete AND fits the roles that the employee is being trained on, which are indicated in a multi-select cell on the second sheet. Is this possible? As of now the formula only works if there is only one selected role.
Help Article Resources
Check out the Formula Handbook template!