Skip to main content
Solved

Formula checkbox using manual checkbox and lookup formula

  • Jun 4, 2024 9:39 PM UTC
  • 0 replies
  • 276 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")

View original
This topic has been closed for replies.

Forum|alt.badge.img+2
  • KCure
  • Author
  • Observing
  • Answer
  • Jun 5, 2024 6:05 PM UTC

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