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.

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 10 months ago

- 4,430 Points

YOu have not finished the formula:

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

(Edited)

- 1,380 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

- 29,924 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,380 Points

This just blew my mind a little. I did

*not*know you could omit the If().Ⲇanom the ultimate (Dan Diebolt), Champion

- 29,924 Points

QuickBase's formula language is an

The equals operator (ie "=") just compares two values of the same type and returns a Boolean value so there is no need for 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!

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