Sending a reminder when date is null or blank

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

I'd like to set a reminder to send 7 days after the creation date, if another date, say fullfillment date is blank or null.  I know how to set up the send 7 days after part, but I'm not sure how to set up the "date being blank or null" part.

Photo of Jay (DDS)

Jay (DDS)

  • 430 Points 250 badge 2x thumb

Posted 3 years ago

  • 0
  • 1
Photo of dwhawe

dwhawe, Champion

  • 908 Points 500 badge 2x thumb
There may be a better way but in these circumstances I create a Formula Checkbox.  The checkbox formula would be:

If(IsNull([Fulfillment Date]),True,False)

I then use the Checkbox as part of the reminder trigger