Getting Started

 View Only
  • 1.  Formula Checkbox based on Text-Multiple Choice

    Posted 04-24-2023 11:53

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


  • 2.  RE: Formula Checkbox based on Text-Multiple Choice

    Posted 04-24-2023 12:01

    Try this: 

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



    ------------------------------
    Kaitlyn Stanley
    ------------------------------



  • 3.  RE: Formula Checkbox based on Text-Multiple Choice

    Posted 04-24-2023 12:02

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



  • 4.  RE: Formula Checkbox based on Text-Multiple Choice

    Posted 04-25-2023 09:50

    Thank you both. Both options work perfectly. 



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