Skip to main content

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 ?

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

Reply


Terms & Conditions