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
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]))
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]))