Skip to main content

IF SWITCH formula not working- what am I doing wrong!?

  • July 29, 2021
  • 2 replies
  • 28 views

Forum|alt.badge.img+1

I’m guessing there’s a syntax error here… I can get the formula to save if I copy a sample formula that includes 3 or 4 arguments, but as soon as I add more, I get an error when trying to save.

PLEASE HELP!

IF(
{Ticket Total} > 0,
SWITCH(
{ShowDate4Formula},
“2021-09-11”, “PIT”,
“2021-09-18”, “MAR”,
“2021-10-02”, “PHL”,
“2021-10-30”, “MD”,
"2021-11-06”, “PAS”,
"2021-11-20”, “SD”,
"2021-12-04”, “DEN”,
"2021-12-18”, “SJ”,
"2022-01-01”, “AUS”
)
)

2 replies

kuovonne
Forum|alt.badge.img+29
  • Brainy
  • July 29, 2021

Check your formula for curly quotes (“ ”) and make sure they are all straight quotes (")


Forum|alt.badge.img+1
  • Author
  • New Participant
  • July 30, 2021

That’s it! Thank you so much!