Discussions

 View Only
  • 1.  Formula checkbox not working for more than one parameter

    Posted 03-10-2023 09:23

    I have a formula checkbox that doesn't seem to work when adding more than one condition. I want it to be true when a duration field is less than 30 days and another multi-select text contains "In-Person".

    My formula is:

    If([Duration-Delivered - Created]<Days(30)
    & Contains([All Session Modalities Next Session Date NOT CANCELLED or DOWNSIZED],"In-Person"), 
    true)

    The first one by itself works fine, If([Duration-Delivered - Created]<Days(30), true). However, when I add the second part the < highlights yellow and says the less than sign cannot be applied on types duration, text.

    Any assistance would be appreciated.



    ------------------------------
    Dawn Rene
    ------------------------------


  • 2.  RE: Formula checkbox not working for more than one parameter

    Posted 03-10-2023 10:51

    From a quick glance you're using & instead of 'and'. 'and' syntax is how Quickbase will combine conditions, where as & is how you combine text values. Same thing goes for 'or'. If you update your formula as follows you should be good.

    If([Duration-Delivered - Created]<Days(30)
    and Contains([All Session Modalities Next Session Date NOT CANCELLED or DOWNSIZED],"In-Person"), 
    true)



    ------------------------------
    Chayce Duncan
    ------------------------------



  • 3.  RE: Formula checkbox not working for more than one parameter

    Posted 03-10-2023 11:02

    Boom! That was it! Thank you!



    ------------------------------
    Dawn Rene
    ------------------------------