Skip to main content
Question

IF formula help

  • September 6, 2018
  • 0 replies
  • 76 views
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.
    This topic has been closed for replies.

    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)
    Terms & ConditionsAccessibility statement