How to add a N/A checkbox for a Date field

  • 0
  • 1
  • Question
  • Updated 11 months ago
  • Answered


I have a table with multiple date fields, but a lot of times my users don't have those dates yet, and I would like them to have the N/A option. Is there a way to add a checkbox next to the date field that says "N/A" and if they click it then the input for the field should be N/A.

I don't want this to be a separate field, because I need it to have a N/A input for a monthly report.

Any help would be great!

Thank you!

Photo of Iris Bonilla

Iris Bonilla

  • 320 Points 250 badge 2x thumb

Posted 11 months ago

  • 0
  • 1
Unfortunately Date fields can only accept dates (or be blank).

However you could create another formula text field that will either populate with your date field or "N/A" if the checkbox you mentioned is checked for use in your monthly report.

If([Checkbox]=true, "N/A", ToText([Date]))