IF formula help

  • 0
  • 1
  • Question
  • Updated 2 months ago
  • Answered
I have a table called "Contacts" and it has a checkbox field called "Form".  I have a related table called "Companies" and it has a Formula Checkbox field called "Contact form".  I need help creating a formula that does the following:

If any contact (from the related company) has the "Form" field checked then mark the "Contact Form" checkbox as checked.
Photo of Mark Comish

Mark Comish

  • 620 Points 500 badge 2x thumb

Posted 2 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 50,850 Points 50k badge 2x thumb
No problem

In the relationship where 1 company has many contacts make s summary count of the # of contacts with a form checked.

Then on the companies record make a formula checkbox field

[# of contacts with Form checked] > 0)
Photo of Mark Comish

Mark Comish

  • 620 Points 500 badge 2x thumb
Perfect! Thank you!