test for string checkbox

Question

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.

chrischris · Answer

YOu have not finished the formula:If([Accounting Solution]=Left("QB Online", 9),true,false)

danladner1 · Answer

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)

chrischris · Answer

if(left([Accounting Solution],9)="QB Online",true,false)Right, you probably don't need the 9.

_anomdiebolt_ · Answer

You probably don't need the If(). Try this:[Accounting Solution] = "QB Online"

chrischris · Answer

That's what I was going to suggest but it's not intuitive.

Forum Discussion

test for string checkbox

Related Content

Formula checkbox using manual checkbox and lookup formula

Using Pipelines to Archive Records Based on Checkbox

Converting delimited text into checkboxes

Checkboxes

Testing for Empty Forms