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