#UNPARSEABLE error

lea.s6

Hello everyone,

I have a problem with my function :

=IF(AND(JOIN(COLLECT({S1}; {QRQC Date}; Date@row; {QRQC Area}; $Area$1); "") = ""; Weekday@row <> 7; Weekday@row <> 1;OR({S1}="/";{S1}="\" ))) ;1; 0)

I don't why this error came. If any person have the answer ?

Thanks you

Kaveri Vipat

Hi lea.s6,

It seems you are using “;” in your formula which is causing the error. I would suggest you use “,” in the formula.

Thank You

Kaveri Vipat, Smartsheet Engineer, Ignatiuz Software

lea.s6

Hi @Kaveri Vipat,

I have tried with "," but the error stay.

Maybe there is an other error in the formula.