Forum Discussion

Qrew Captain

2 years ago

Formula error

Please help me make this work...thx If( [BUDGET.030123]=true, [Job - Copy of Related Projects - Window Wrap-0 Sides]=true, ([Related Priced Spec2 - Related MPS2 - Corner Bead1-1/4X9' Metal/Bo...

Qrew Captain

2 years ago

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
/
------------------------------

BuildPro
Qrew Captain
2 years ago
Would you mind copying/pasting my formula using your explanation? thx

------------------------------
BuildPro
------------------------------
- BlakeHarrison
  Qrew Captain
  2 years ago
  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
  /
  ------------------------------