Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

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

Topic Labels: Formulas
965 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Joseph_Boerner
4 - Data Explorer
4 - Data Explorer

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 2

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

Joseph_Boerner
4 - Data Explorer
4 - Data Explorer

That’s it! Thank you so much!