Help

Simple Switch formula

Topic Labels: Formulas
1413 4
cancel
Showing results for 
Search instead for 
Did you mean: 
John_White
5 - Automation Enthusiast
5 - Automation Enthusiast

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