Forum Discussion
QuickBaseJunkie
Qrew Legend
7 years agoUnfortunately 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]))