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