Getting Started

Expand all | Collapse all

Checkbox Formula Field Error

  • 1.  Checkbox Formula Field Error

    Posted 12-21-2020 11:43

    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
    ------------------------------


  • 2.  RE: Checkbox Formula Field Error

    Posted 12-21-2020 11:44

    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
    ------------------------------



  • 3.  RE: Checkbox Formula Field Error

    Posted 29 days ago

    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
    ------------------------------



  • 4.  RE: Checkbox Formula Field Error

    Posted 29 days ago
    Edited by Blake Harrison 29 days ago

    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/
    ------------------------------



  • 5.  RE: Checkbox Formula Field Error

    Posted 29 days ago

    Awesome - thank you!



    ------------------------------
    Jack Woods
    ------------------------------