Forum Discussion

AlexBennett3's avatar
AlexBennett3
Qrew Trainee
5 years ago

Formula Advice(Adding a day to duration if > X)

Hey Everyone,  Wanted to see if I could get some direction on what I'm trying to do. I have a formula that displays a duration on a calendar based on previous fields numeric values and start dates....
App builders
Formulas and functions
AlexBennett3's avatar
AlexBennett3
Qrew Trainee
5 years ago
Maybe a Case() Statement for this? I'm just not sure how to reformat this code to not effect the other if statements and only the Plumbing.

------------------------------
Alex Bennett
------------------------------
  • AustinK's avatar
    AustinK
    Qrew Commander
    5 years ago
    The issue is likely in the order your lines are listed. The way Quick Base works with a formula is it takes the first thing that is true and runs with that while not bothering to read the rest of your formula.

    If([Plumbing Duration] > 0, ToDate(WeekdayAdd(ToWorkDate([Start(3)]), [Plumbing Duration])),
    If([Plumbing Duration] > 4, ToDate(WeekdayAdd(ToWorkDate([Start(3)]), [Plumbing Duration]+1))

    Looking at those 2 lines the only thing that would ever be true is the first line. Because plumbing duration above 0 is always true even if it is also above 4. Swap those 2 lines with the > 4 line on top and at least the plumbing part may start working. I did not test this but hopefully my explanation on how the formula works helps you fix this if my suggestion does not.