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
------------------------------
  • Thx for posting you code and the error message, you were missing a comma in this line just before that last  [Schuchart Cost Code].


    [Work Type]="RD-Reactive"or [Work Type]="RP-Reactive Project"or [Work Type]="PJ-Planned Job and [Schuchart Cost Code]<>"", [Schuchart Cost Code],

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------