How to checkbox when first and second criteria match in a dropdown list
Hi fellow team members,
I can't figure how to check a box when first and second criteria match in a dropdown multi select list. Please reference below. Here's an example of what I am trying to accomplish. I want the column with the checkbox to 'Check' when the all the values in the 'List of Tests' column has been assigned in the 'Assigned Test' column based on the 1st criteria 'ID Material'. I'm familiar with Countif(s) functions, but I can't seem to get this right. For some reason, the dropdown multi select list is difficult to put together.
Help Article Resources
Check out the Formula Handbook template!