test for string checkbox
If([Accounting Solution]=Left("QB Online", 9), true) Why doesn't this formula check the box in a Formula Checkbox field? [Accounting Solution] is multiple choice text field containing entries such...
Forum Discussion
if(
left([Accounting Solution],9)="QB Online",true,false)
Right, you probably don't need the 9.
- You probably don't need the If(). Try this:
[Accounting Solution] = "QB Online"
- That's what I was going to suggest but it's not intuitive.
- This just blew my mind a little. I did not know you could omit the If().
- QuickBase's formula language is an almost pure functional language where every valid formula returns a consistent value. The only exception to purity are those formulas that use the functions Today() or Now().
The equals operator (ie "=") just compares two values of the same type and returns a Boolean value so there is no need for an If() function.
