Help

Re: Problem with this formula

758 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Samuel_Saunier
4 - Data Explorer
4 - Data Explorer

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
Ron_Daniel
8 - Airtable Astronomer
8 - Airtable Astronomer

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