Forum Discussion

KCure's avatar
KCure
Qrew Member
6 months ago

Formula checkbox using manual checkbox and lookup formula

Hello,

I have a checkbox field that can be manually checked, and a separate formula checkbox field that I would like to be checked if either the manual checkbox field is checked, or if a certain parameter is met. In this case, the parameter is that the Schedule Notes field contains the term "bip". I created the formula below, and the formula checkbox field is checked for sites meeting the specified parameter, but not for sites where the For BiP_manual checkbox field has been manually checked. Can anyone help me figure out what edits I need to make to the formula to accomplish what I need here?

If([For BiP_manual]=true, Contains([Schedule Notes],"bip"))

formulas
  • KCure's avatar
    KCure
    6 months ago

    Well, I figured it out. I believe it was the "IF" function that was causing the issue, and I just needed the parameters with an "or". Here's what I ultimately came up with that worked:

    [For BiP_manual]=true or Contains([Schedule Notes],"bip")

  • KCure's avatar
    KCure
    Qrew Member
    6 months ago

    Well, I figured it out. I believe it was the "IF" function that was causing the issue, and I just needed the parameters with an "or". Here's what I ultimately came up with that worked:

    [For BiP_manual]=true or Contains([Schedule Notes],"bip")