Skip to main content
Solved

Formula checkbox using manual checkbox and lookup formula

  • June 4, 2024
  • 0 replies
  • 249 views
Forum|alt.badge.img+2

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

Best answer by KCure

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

This topic has been closed for replies.

Forum|alt.badge.img+2
  • KCure
  • Author
  • Quickbase Alumni
  • Answer
  • June 5, 2024

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

Terms & ConditionsAccessibility statement