Forum Discussion

ShereeBrown's avatar
ShereeBrown
Qrew Cadet
7 years ago

Automate Checkbox Field

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. 
Formulas and functions
  • RobIV's avatar
    RobIV
    Qrew Cadet
    7 years ago
    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