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
    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


    Kaveri Vipat

    Senior Associate - Smartsheet Development, Ignatiuz Software

    2023 Core Product Certified

    Did this answer help you? Show some love by marking this answer as "Insightful💡" or "Awesome❤️" and "Vote Up⬆️"

  • lea.s6
    lea.s6 ✭✭✭✭

    Hi @Kaveri Vipat,

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

    Maybe there is an other error in the formula.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!