If(
[BUDGET.030123]=true,
[Job - Copy of Related Projects - Window Wrap-0 Sides]=true,
([Related Priced Spec2 - Related MPS2 - Corner Bead1-1/4X9' Metal/Box $]*0.65)
This is the specific section where I'm seeing your issue. Your first IF statement (Criteria 1) is:
If(
[BUDGET.030123]=true,
But then, you have this after it:
[Job - Copy of Related Projects - Window Wrap-0 Sides]=true,
Which looks like it SHOULD be a 2nd IF / Criteria 2 so that if both of these are TRUE, this would be the result (THEN) of the formula:
([Related Priced Spec2 - Related MPS2 - Corner Bead1-1/4X9' Metal/Box $]*0.65)
If that's correct that both of those statements need to be TRUE for this calculation to be used, you have to connect them with an AND like this:
If(
[BUDGET.030123]=true AND
[Job - Copy of Related Projects - Window Wrap-0 Sides]=true,
([Related Priced Spec2 - Related MPS2 - Corner Bead1-1/4X9' Metal/Box $]*0.65),
[Job - Copy of Related Projects - Window Wrap-3 Sides]=true,
([Related Priced Spec2 - Related MPS2 - Corner Bead1-1/4X9' Metal/Box $]*0.85),
[Job - Copy of Related Projects - Window Wrap-4 Sides]=true,
([Related Priced Spec2 - Related MPS2 - Corner Bead1-1/4X9' Metal/Box $]*1),
[Job - Copy of Related Projects - Window Wrap-0 Sides]=true,
([Related Priced Spec2 - MPS - ID-Corner Bead1-1/4X9' Metal/Box $]*0.65),
[Job - Copy of Related Projects - Window Wrap-3 Sides]=true,
([Related Priced Spec2 - MPS - ID-Corner Bead1-1/4X9' Metal/Box $]*0.85),
[Job - Copy of Related Projects - Window Wrap-4 Sides]=true,
([Related Priced Spec2 - MPS - ID-Corner Bead1-1/4X9' Metal/Box $]*1)
)
Of course, there are other possibilities, but I'd need to know what you were trying to accomplish with this.
------------------------------
Blake Harrison
bharrison@datablender.io
/
------------------------------