Skip to main content

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”

)

)

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


That’s it! Thank you so much!


Reply