Discussions

Expand all | Collapse all

IF formula help

  • 1.  IF formula help

    Posted 09-06-2018 19:02
    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.


  • 2.  RE: IF formula help

    Posted 09-06-2018 19:12
    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)


  • 3.  RE: IF formula help

    Posted 09-06-2018 19:27
    Perfect! Thank you!