Forum Discussion

JackWoods's avatar
JackWoods
Qrew Trainee
4 years ago

Checkbox Formula Field Error

Looking to make a simple little formula field (Checkbox) where if the Task Name is called "Hosted Weekly Call" & the Status= Completed it will mark the task as "True" and check the box. I'm getting an error in my code though. please advise.

If([Task Name]="Hosted Weekly Call" & [Status]="Completed","True","False")

Getting a code error that the operator = can't be applied on types bool,text



------------------------------
Jack Woods
------------------------------
  • An "&" means concatenation

    Try this

    If([Task Name]="Hosted Weekly Call" and [Status]="Completed","True","False")



    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • JackWoods's avatar
      JackWoods
      Qrew Trainee

      How would I make this an OR statement with multiple scenarios?

      [Task Name]="Hosted Weekly Call" and [Status]="Completed"
      OR
      [Task Name]="External Kick-Off Call " and [Status]="Completed"
      OR
      [Task Name]="Internal Kick-Off Call " and [Status]="Completed"

      I get an error that says their are extra characters beyond the end of my formula. Do I have to change this into an If statement?

      Thank you



      ------------------------------
      Jack Woods
      ------------------------------
      • BlakeHarrison's avatar
        BlakeHarrison
        Qrew Captain

        Individual sets of criteria have to be enclosed in parentheses ()

        Criteria A OR

        (Criteria B AND Criteria C)

        For your example, I would set it up like this:

        [Status]="Completed" AND
        ([Task Name]="Hosted Weekly Call"  
        OR
        [Task Name]="External Kick-Off Call " 
        OR
        [Task Name]="Internal Kick-Off Call ")



        ------------------------------
        Blake Harrison
        bharrison@datablender.io
        DataBlender - Quick Base Solution Provider
        Atlanta GA
        404.800.1702 / http://datablender.io/
        ------------------------------