Forum Discussion

AshleyHarris's avatar
AshleyHarris
Qrew Trainee
2 years ago

Formula Checkbox based on Text-Multiple Choice

I need help with a formula for a Formula - Checkbox field.

When the value in a Text-Multiple Choice is Yes then Check the Box. 

This is where I am currently at. I'm getting an error on the "Yes". 

IF(Contains(ToText([Registered Agent for any Entity]),Yes) = true)



------------------------------
Ashley Solomon
------------------------------
  • KaitlynStanley's avatar
    KaitlynStanley
    Qrew Trainee
    2 years ago

    Try this: 

    IF([Registered Agent for any Entity] = "Yes", true)



    ------------------------------
    Kaitlyn Stanley
    ------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    2 years ago

    You can do this

    IF([Registered Agent for any Entity] = "Yes", true)

    but you can also simply do this. 

    [Registered Agent for any Entity] = "Yes"

    for the latter simplified formula you are essentially making a statement and Quickbase will come back and tell you if what you have said is true.








    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    • AshleySolomon's avatar
      AshleySolomon
      Qrew Trainee
      2 years ago

      Thank you both. Both options work perfectly. 



      ------------------------------
      Ashley Solomon
      ------------------------------