Forum Discussion

JustinParker's avatar
JustinParker
Qrew Trainee
7 years ago

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...
Formulas and functions
JIMLIEDER1's avatar
JIMLIEDER1
Qrew Cadet
7 years ago
You can use the Case formula.  Create a new formula Text field named [Competency] with a formula like this:

Case([Current Job Title],
"CM Specialist (Junior)","Configuration Management", 
"CM Specialist (Mid)", "Configuration Management", 
"Cyber Security Engineer (Junior)", "Cyber Security",
"Other", null)

More info: https://login.quickbase.com/db/6ewwzuuj?a=dr&r=ei&rl=9fk