I have google sheets with a list containing: user, access request, justification (why they need access). I need to classify these requests into 5 categories. Depending on the terms used in the justification, I would consider it classified in one of the categories. Example: I need this access to fix an issue (category: fix). The thing is, the justification field is text-free, and there are a couple of words that could mean the same category(e.g.: troubleshoot, debug -> all go to the Fix category). I have another list compiled with the most used words and the corresponding category.
Question: how do I search in my access request list, in each justification and match it to the related category? I've tried this but it's not working:
=IFS(MATCH("*debug*",T2:T9,0),MATCH("*fix*",T2:T9,0),MATCH("*troubleshoot*",T2:T9,0),"Not Fix category")
Justifications are in the T column.
Aucun commentaire:
Enregistrer un commentaire