Create a Formula Text Field that converts job titles to competencies
I have an existing text field [Current Job Title] that has over 50 different types of Job Titles.
To better bucket employees I would like to create a Text Formula Field [Competency] that based on the job title selected, the Competency would automatically be selected for that employee.
For example:
If an employee has one of these job titles I would like the [Competency] field to automatically say "Configuration Management"
And so on and so on. I'll probably have around 10 competencies total
Any help would be greatly appreciated.
To better bucket employees I would like to create a Text Formula Field [Competency] that based on the job title selected, the Competency would automatically be selected for that employee.
For example:
If an employee has one of these job titles I would like the [Competency] field to automatically say "Configuration Management"
- CM Specialist (Junior)
- CM Specialist (Mid)
- CM Specialist (Mid)/DPM
- CM Specialist (Senior)
- Cyber Security Engineer (Junior)
- Cyber Security Engineer (Mid)
- Cyber Security Engineer (Senior)
- Cybersecurity Analyst
- Cybersecurity Engineer (Senior)
- Cybersecurity Policy Consultant (Senior)
And so on and so on. I'll probably have around 10 competencies total
Any help would be greatly appreciated.
