BuildPro
Qrew Captain
2 years ago

Formula error

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),
[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)

)

------------------------------
BuildPro
------------------------------
• It looks like you're trying to chain together multiple pieces in the IF criteria, but the way that you're doing it won't work. Here's what I'm seeing:

`IF(Criteria 1, Criteria 2, Then,`

`     Criteria 3, Then,`

`     Criteria 4, Then,`

`     Criteria 5, Then,`

`     Criteria 6, Then,`

`     Criteria 7, Then)`

If you want to have Criteria 1 and 2 be required for the first Then, that would be:

`IF(Criteria 1 AND Criteria 2, Then,`

`     Criteria 3, Then,`

`     Criteria 4, Then,`

`     Criteria 5, Then,`

`     Criteria 6, Then,`

`     Criteria 7, Then)`

------------------------------
Blake Harrison
bharrison@datablender.io
/
------------------------------
• Would you mind copying/pasting my formula using your explanation?  thx

------------------------------
BuildPro
------------------------------
• `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
/
------------------------------