Forum Discussion

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

      Would you mind copying/pasting my formula using your explanation?  thx



      ------------------------------
      BuildPro
      ------------------------------
      • BlakeHarrison's avatar
        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
        /
        ------------------------------