Skip to main content

Simple Switch formula

  • September 21, 2020
  • 4 replies
  • 20 views

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

ScottWorld
Forum|alt.badge.img+35
  • Genius
  • September 21, 2020

Put quotation marks around your switch values.


  • Author
  • New Participant
  • September 21, 2020

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”,
)


ScottWorld
Forum|alt.badge.img+35
  • Genius
  • September 21, 2020

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.


  • Author
  • New Participant
  • September 21, 2020

You will also need to remove the final comma.


WOOOOOOOOO!

Thx a bunch