Syntax Error

Question

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

MarkShnierYou · Answer

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

Sign up

Login to the community