Feb 15, 2023 09:54 AM
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?
Solved! Go to Solution.
Feb 15, 2023 10:38 AM
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 🙂
Feb 15, 2023 10:38 AM
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 🙂