Forum Discussion

BuildPro's avatar
BuildPro
Qrew Captain
15 days ago

FORMULA ASSISTANCE NEEDED

This is my goal...getting error message tho.  Have tried several other ways, but can't get it to work...thanks for your help.

If(
[Task - USE DEFAULT UNIT COUNT]=true,[Task - Default Unit Count],
[Task]="CAULK HVAC VENTS", [Task - Default Unit Count],
[Task]="HANG",[FIELD BOARD COUNT.TO PAY],
[Task]="Drywall.Item",[Take/Off Calc - NON-STRUCTURAL ITEM COUNT],
[Task]="SCRAP",[Job - Maximum FIELD BOARD COUNT.TO PAY],
[Task]="FINISH" and [Job - Project - GARAGE.FINISH-TAPE ONLY]=true,([Job - Maximum FIELD BOARD COUNT.TO PAY]-13),
[Job - Maximum FIELD BOARD COUNT.TO PAY], ****GETTING ERROR MESSAGE-expecting boolean, but found number*****

[Task]="SAND" and [Job - Project - GARAGE.NO SAND]=true, ([Job - Maximum FIELD BOARD COUNT.TO PAY]-24),
[Job - Maximum FIELD BOARD COUNT.TO PAY],

[Task]="PRIME P/U" and [Job - Project - GARAGE.NO PRIME PT/UP]=true,([Job - Maximum FIELD BOARD COUNT.TO PAY]-24),
[Job - Maximum FIELD BOARD COUNT.TO PAY],

[Task]="PRIME",  [Job Specific Take/Off - Take/Off - Total CEILING CALC HSF],
[Task]="2nd COAT",[Job - Maximum Take/Off - BASE HOUSE.CALCULATED HSF],
[Task]="FINAL T/U",[Job - Total Take/Off Calc - CEILING CALC HSF],
[Task - Task Phase]="Paint.Interior.Item", [Take/Off Calc - NON-STRUCTURAL ITEM COUNT],
[Task - Task Phase]="Paint.Exterior.Item", [Take/Off Calc - NON-STRUCTURAL ITEM COUNT])

  • this part is incorrecty

    [Task]="FINISH" and [Job - Project - GARAGE.FINISH-TAPE ONLY]=true,([Job - Maximum FIELD BOARD COUNT.TO PAY]-13),
    [Job - Maximum FIELD BOARD COUNT.TO PAY], 

     

    because on the last line its expecting another condition test.