How to add a N/A checkbox for a Date field
Hello! 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 da...
Forum Discussion
QuickBaseJunkie
Qrew Legend
Qrew LegendUnfortunately 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]))
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]))