Help

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

Simple Switch formula

Topic Labels: Formulas
360 4
cancel
Showing results for 
Search instead for 
Did you mean: 

This seems like it shouldn’t be that hard…

SWITCH({Content Type},
Long-read, “$100 USD”,
Standard-length, “$25 USD”,
Photo, “$25 USD”,
Video, “$40 USD”,
Cartoon, “$25 USD”,
)

4 Replies 4

Put quotation marks around your switch values.

Tried that and still got the error (and I’ve used straight quotes)

SWITCH(
{Content Type},
“Long-read”, “$100 USD”,
“Standard-length”, “$25 USD”,
“Photo”, “$25 USD”,
“Video”, “$40 USD”,
“Cartoon”, “$25 USD”,
)

You will also need to remove the final comma.

WOOOOOOOOO!

Thx a bunch