Discussions

Expand all | Collapse all

Syntax Error

  • 1.  Syntax Error

    Posted 15 days ago
    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]
    )

    Error Message


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


  • 2.  RE: Syntax Error

    Posted 15 days ago
    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
    ------------------------------