Forum Discussion

DirkRuana's avatar
DirkRuana
Qrew Captain
5 years ago

Syntax Error

Hello:

Having trouble identifying syntax error.

Below is the formula and related error message.

The first line is supposedly "expecting comma."

If anyone can help, I'd be very appreciative.

Dirk

----------------------------------------------------------------------------------------------------------------------------------------------------------


If(
[Work Type]="RD-Reactive"or [Work Type]="RP-Reactive Project"or [Work Type]="PJ-Planned Job and [Schuchart Cost Code]<>""[Schuchart Cost Code],
[Work Type]="RD-Reactive"or [Work Type]="RP-Reactive Project"or [Work Type]="PJ-Planned Job and [Schuchart Cost Code]="",([Building - Group Identifier] & [Record ID#]),
[Work Type]="250K Project" and [Schuchart Cost Code]=" ", [Schuchart Cost Code]
)



------------------------------
Dirk Ruana
------------------------------
  • LeeGilmore's avatar
    LeeGilmore
    Quickbase Staff
    Dirk,

    Not sure if this will fix it but I highlighted a few spots that might need a comma or a quote mark.



    ------------------------------
    Lee Gilmore
    ------------------------------
    • DirkRuana's avatar
      DirkRuana
      Qrew Captain
      Hi Lee:

      Got it!  Thank you for the kindly assistance.

      Dirk

      ------------------------------
      Dirk Ruana
      ------------------------------