How to search through data in a column and check if some specific criteria meets

Question

Hi all,

I would like to search through the Level column and check if this column has all "Senior 2" "Associate 2", "Associate" and "Intern". If this condition is met, then it will be proceeded further, if not then it needs to go to another input to fill up 1 of the 4 roles mentioned above.

Thank you in advance!

philipmannering · Accepted Answer

I think you want to filter your data using the Filter Tool. You can use the expression,

Level IN("Senior 2" "Associate 2", "Associate", "Intern")

with the Filter set to Custom Filter.

Hope this helps.

Thanks,

Philip