Issue with Switch formula

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!

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.)

Good catch @ScottWorld!

They were in fact curly quotes

@Bishoy_Gaid., you will probably have to change all the quotes.

Mary Kay

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.