Forum Discussion

PaulElliott's avatar
PaulElliott
Qrew Member
2 years ago
Solved

If then questions

I have a series of If conditions I want to figure out but am getting a boolean error at the end of the statement. If([FC Shake Type2]="Staggered Shake", [Actual Shake Siding], //Condition 1      ...
Formulas and functions
  • MarkShnier__You's avatar
    MarkShnier__You
    2 years ago
    In Quickbase syntax it's simpler than excel. Just list your conditions vertically with just one IF.  But also this is a formula text field type so you cannot have a numeric 0 as a result. Hence I added quotes around the 0. 

    If(
    [FC Shake Type2]="Staggered Shake", [Actual Shake Siding], //Condition 1

     [FC Shake Type2]="Straight Shake","0",  //Condition 2

    [City Set Shake Type]="Staggered Shake",[Actual Shake Siding],  //Condition 3

     [Bid Set Shake Type]="Staggered Shake",[Actual Shake Siding],"0")

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------
MarkShnier__You's avatar
MarkShnier__You
Qrew Champion
2 years ago
In Quickbase syntax it's simpler than excel. Just list your conditions vertically with just one IF.  But also this is a formula text field type so you cannot have a numeric 0 as a result. Hence I added quotes around the 0. 

If(
[FC Shake Type2]="Staggered Shake", [Actual Shake Siding], //Condition 1

 [FC Shake Type2]="Straight Shake","0",  //Condition 2

[City Set Shake Type]="Staggered Shake",[Actual Shake Siding],  //Condition 3

 [Bid Set Shake Type]="Staggered Shake",[Actual Shake Siding],"0")

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------