Skip to main content
Solved

Help With Switch Formula

  • February 28, 2020
  • 6 replies
  • 30 views
H

SWITCH(PageID, "18479402361", "NKH", "8532248414", “WWP”, "8271670852", “LLS”, "342294162453301", “PP”, "27817332304", “AFSP”, "55701226138", “AHA”, "15687409793", “WWF”, "12692786774", “ALS, "184404096774", “LUPUS”, "105229062888132", “SSS”, "25372476424", “BFAS”, "12596759677", “RAICES”, "14084625156", “SGK”, “13793312555", “MAW”, "1562713090633117", “OUR”, "20876805343", “MOD”, "100438444321", “CCA”, "8492293163", “EDF”, "111541054636", “BTM”, "10331123781", “SO”, "371566686229476", “ADAA”, "342091725962792", “M22”, "8047221596", “STC”, "11791104453", “NRDC”, "81517275796", “UNICEF”, "512423278811960", “DS”, "122531741163825", “ALF”, "22902828717", “BB”, "332378771195", “CF”, "97646191545", “HA”, "44224524016", “AKF”, "332077995968", “LCRF”, "84618074710", “CCC”, "95155519857", “BLISS”, "24470472733", “TP”, "7271534916", “FFB”, "N/A")

Here is my switch formula currently. I have genuinely been looking at this for 45 minutes now and I cannot seem to figure out why it is erroring out. I’m sure it’s a very simple issue but I cannot seem to find the cause. Please let me know if you see any errors. Thanks!

Best answer by M_k

Your formula has a mix of straight quotes "..." and curly quotes “...”.

Make sure you use only straight quotes.


Hi @Hunter_Casillas

There was a quote missing from one of the strings of letters (ALS.).

Mary K

6 replies

kuovonne
Forum|alt.badge.img+29
  • kuovonne
  • Brainy
  • February 28, 2020

Your formula has a mix of straight quotes "..." and curly quotes “...”.

Make sure you use only straight quotes.

M
Forum|alt.badge.img+20
  • M_k
  • Inspiring
  • Answer
  • February 28, 2020

Your formula has a mix of straight quotes "..." and curly quotes “...”.

Make sure you use only straight quotes.


Hi @Hunter_Casillas

There was a quote missing from one of the strings of letters (ALS.).

Mary K

H
  • Hunter_Casillas
  • Author
  • Participating Frequently
  • March 2, 2020

Your formula has a mix of straight quotes "..." and curly quotes “...”.

Make sure you use only straight quotes.


Didn’t even notice that, thank you!

E
Forum|alt.badge.img+8
  • E_K
  • Known Participant
  • March 4, 2020

Any idea, what is max number of patterns and results SWITCH() function can handle?
If that is exceeded, what might be a sidewalk (but not nested IF, I am have about 180 patterns. Thank you

kuovonne
Forum|alt.badge.img+29
  • kuovonne
  • Brainy
  • March 4, 2020

Any idea, what is max number of patterns and results SWITCH() function can handle?
If that is exceeded, what might be a sidewalk (but not nested IF, I am have about 180 patterns. Thank you


I haven’t seen a documented limit on the SWITCH function. I have see some very long formulas.

On the other hand, you are probably better off with writing a script for the scripting block (unless the info changes frequently). I think it would be much easier. The syntax for a JavaScript SWITCH is a bit different from Airtable’s formula fields.

E
Forum|alt.badge.img+8
  • E_K
  • Known Participant
  • March 4, 2020

I haven’t seen a documented limit on the SWITCH function. I have see some very long formulas.

On the other hand, you are probably better off with writing a script for the scripting block (unless the info changes frequently). I think it would be much easier. The syntax for a JavaScript SWITCH is a bit different from Airtable’s formula fields.


Thank you, @kuovonne. I am a total lamer in JavaScript and will probably continue with SWITCH() function. So far it handles my 180 patterns and results.

Terms & ConditionsAccessibility statement