Forum Discussion

BuildPro's avatar
BuildPro
Qrew Captain
2 months 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.