IF formula help

  • 0
  • 1
  • Question
  • Updated 10 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

  • 790 Points 500 badge 2x thumb

Posted 10 months ago

  • 0
  • 1
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

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