Skip to main content
Question

Automate Checkbox Field

  • August 14, 2018
  • 0 replies
  • 29 views
I am trying to place a check in checkbox field [Tests Scheduled] when 3 of 3 date fields have been populated: [MRI date], [CT date] and [Endo date]. I have tried actions and automations. I don't want form rules because these dates are entered in grid edit mode. I think a checkbox formula field will work, but I 'm not sure how to write the formula. Help please!  I don't have any training in formulas, I have looked at numerous posts for possible answers without finding an answer. 
    This topic has been closed for replies.

    • RobIV
    • Registered
    • August 14, 2018
    The formula for the [Tests Scheduled] formula checkbox field should look something like:

    If(
    IsNull([MRI date]) OR IsNull([CT date]) OR IsNull([Endo date]),
    false,
    true
    )

    Should return 'false' (unchecked) if any of the dates are null; 'true' otherwise.

    See if that works.

    Thanks,

    ~Rob
    • ShereeBrown
    • Author
    • Registered
    • August 14, 2018

    Thank you, it works!  So simple too!
    Terms & ConditionsAccessibility statement