Skip to main content
Question

test for string checkbox

  • May 11, 2018
  • 0 replies
  • 32 views
Forum|alt.badge.img+1
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.
      This topic has been closed for replies.

      • ChrisChris
      • Registered
      • May 11, 2018

      YOu have not finished the formula:

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

      • DanLadner1
      • Registered
      • May 11, 2018
      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
      • Registered
      • May 11, 2018

      if(

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

      Right, you probably don't need the 9.

      Forum|alt.badge.img+1
      • RothHensley
      • Author
      • Registered
      • May 12, 2018
      Contains([Accounting Solution],"QB Online") 

      suggested by Kevin Martens also works.  Thanks for this discussion.  Very helpful!
      Terms & ConditionsAccessibility statement