Help

Formula Error - Switch Function

Solved
Jump to Solution
424 1
cancel
Showing results for 
Search instead for 
Did you mean: 
EvanCasey
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi all, 

Semi-new user to the tool here, and still learning the formulas. I have the following issue: 

I am using the switch function to categorize certain single select options into different categories (in this case, which statuses in the HR systems relate to an overall designation of accepted, dispositioned, interviewing, etc)

My full formula is below. The issue is the very last line item: 

'Doesn't Meet Min Qual', 'Dispositioned'

This line has the apostrophe in the word "Doesn't", and that seems to be invalidating the formula. Everything worked great until I added that line, and then it breaks. I unfortunately can't change the wording of the option, since it comes directly from our system. Is there any way to get the formula to work, and ignore that specific apostrophe?

 

SWITCH({Current HR Status}, 
'Prepare Offer - Pro', 'Accept', 
'Send Offer for Approval - Pro', 'Accept',
'Hold Offer Accept - Pro (Internal)', 'Accept',
'Hold Offer Accept - Pro (External)', 'Accept',
'Hired - (Internal)', 'Accept',
'Hired - (External)', 'Accept',
'Extend Offer - Pro (External)', 'Accept',
'Leader Interview Completed - Pro', 'Offer Decision Pending',
'Recruiter Phone Screen Scheduled - Pro', 'Interviewing',
'Presented to Leader - Pro', 'Interviewing',
'Schedule Leader Interview - Pro', 'Interviewing',
'Leader Interview Scheduled - Pro', 'Interviewing',
'Applied - Pro', 'In Screening',
'Meets Min Qual - Pro', 'In Screening',
'On-Demand Video Interview Requested- Pro', 'In Screening',
'On-Demand Video Interview Completed - Pro', 'In Screening',
'0-Filed', 'Dispositioned',
'Not Reviewed', 'Dispositioned',
'Hired into another req', 'Dispositioned',
'Candidate Decline Offer', 'Dispositioned',
'Candidate Not Interested', 'Dispositioned',
'Company Not Interested', 'Dispositioned',
'Does Not Meet COVID Pre Screen', 'Dispositioned',
'Does Not Meet GQ Pre Screen', 'Dispositioned',
'Doesn't Meet Min Qual', 'Dispositioned'
)
 
Thanks in advance!!
1 Solution

Accepted Solutions
EvanCasey
5 - Automation Enthusiast
5 - Automation Enthusiast

After some additional googling and trial and error, I think I may have answered my own question. 

Since the extra apostrophe in "Doesn't" is messing up the formula, i tried using Doesn\'t instead, and it worked! Learn something new every day 🙂 

See Solution in Thread

1 Reply 1
EvanCasey
5 - Automation Enthusiast
5 - Automation Enthusiast

After some additional googling and trial and error, I think I may have answered my own question. 

Since the extra apostrophe in "Doesn't" is messing up the formula, i tried using Doesn\'t instead, and it worked! Learn something new every day 🙂