Help

Issue with Switch formula

Topic Labels: Formulas
839 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Bishoy_Gaid
4 - Data Explorer
4 - Data Explorer

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!

2 Replies 2

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