Dec 04, 2020 01:53 PM
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!
Dec 04, 2020 07:32 PM
You’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.)
Dec 05, 2020 07:40 PM
Good catch @ScottWorld!
They were in fact curly quotes
@Bishoy_Gaid., you will probably have to change all the quotes.
Mary Kay
