DirkRuana
5 years agoQrew Captain
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
------------------------------
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
------------------------------