Skip to main content

Problem with this formula

  • January 25, 2023
  • 1 reply
  • 24 views
S
Forum|alt.badge.img+1

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

Ron_Daniel
Forum|alt.badge.img+21
  • Ron_Daniel
  • Inspiring
  • January 25, 2023

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

    Terms & ConditionsAccessibility statement