Automate Checkbox Field

  • 0
  • 1
  • Question
  • Updated 3 months ago
  • Answered
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. 
Photo of sheree brown

sheree brown

  • 150 Points 100 badge 2x thumb

Posted 3 months ago

  • 0
  • 1
Photo of Rob White IV

Rob White IV

  • 948 Points 500 badge 2x thumb
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
(Edited)
Photo of sheree brown

sheree brown

  • 150 Points 100 badge 2x thumb

Thank you, it works!  So simple too!