# test for string checkbox

• 0
• Question
• Updated 1 year ago
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 as:  QB Online Essentials, QB Online Plus, etc.
• 30 Points

Posted 1 year ago

• 0
• 4,430 Points YOu have not finished the formula:

If([Accounting Solution]=Left("QB Online", 9),true,false)

(Edited)
• 1,580 Points If you want the box to be checked if the value in the Accounting Solution field is "QB Online", this should work:
`If([Accounting Solution]="QB Online", true)`
• 4,430 Points if(

left([Accounting Solution],9)="QB Online",true,false)

Right, you probably don't need the 9.

(Edited)

Ⲇanom the ultimate (Dan Diebolt), Champion

• 30,224 Points You probably don't need the If(). Try this:

`[Accounting Solution] = "QB Online"`
• 4,430 Points That's what I was going to suggest but it's not intuitive.
• 1,580 Points This just blew my mind a little. I did not know you could omit the If().

Ⲇanom the ultimate (Dan Diebolt), Champion

• 30,224 Points 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.
• 30 Points
Contains([Accounting Solution],"QB Online")

suggested by Kevin Martens also works.  Thanks for this discussion.  Very helpful!