Skip to main content
Question

Formula error

  • March 3, 2023
  • 0 replies
  • 49 views
Forum|alt.badge.img+11

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
    • Quickbase Alumni
    • March 3, 2023

    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
    /
    ------------------------------
    Terms & ConditionsAccessibility statement