Hi all,
What am I doing wrong here?
SWITCH(Status, ‘Am Pending’, ‘Pending’, ‘Vendor Pending’, ‘Pending’, ‘Vendor Research’, ‘Pending’ ‘Board Pending’, ‘Pending’)
I would like to return the same value which is Pending.
Thanks in advance!
Issue with Switch formula
+35You’re missing a comma before Board Pending.
(Also, make sure that all your quotation marks are straight quotes instead of curly quotes. You may already have it this way, but this forum will convert straight quotes into curly quotes unless you wrap the code in backticks.)
+20You’re missing a comma before Board Pending.
(Also, make sure that all your quotation marks are straight quotes instead of curly quotes. You may already have it this way, but this forum will convert straight quotes into curly quotes unless you wrap the code in backticks.)
Good catch @ScottWorld!
They were in fact curly quotes
@Bishoy_Gaid., you will probably have to change all the quotes.
Mary Kay
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.