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?