Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Issue with Switch formula

Topic Labels: Formulas
264 2
Showing results for 
Search instead for 
Did you mean: 

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