Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Problem with this formula

Topic Labels: Automations Formulas
74 1
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi there, 

I have a single select field name "Département" and I want to concatene the 2 first letters (later for automation).

I have a problem with this formula :

IF(
  OR(
    {Département} = "75", 
    {Département} = "78", 
    {Département} = "77", 
    {Département} = "91", 
    {Département} = "92", 
    {Département} = "93", 
    {Département} = "94", 
    {Département} = "95"
  ), 
  LEFT({Département}, 2), 
  ""
)
Erreur : Missing opening parenthesis "(".

Can someone help me ?
1 Reply 1

There's nothing wrong with your formula as posted (see screencaps). I copied and pasted it, and there are no errors.

Screen Shot 2023-01-25 at 8.15.52 AM.pngScreen Shot 2023-01-25 at 8.16.08 AM.png