I want to automatically categorize items by language based on the text in the another column. Ex: If the Column contains EN in the Name, then the status should change to English. Same for FR to French, ES to Spanish and DE to German. How to do this? Please help me here!
What type of column is FR/SP etc?