Not IsNull
If date field is not empty, return "COMPLETED" in text field. If [Sub Payroll - Actual Finish Date] is empty [Status Completed]=COMPLETED ------------------------------ Lynne8817 Lynne8817 --...
Forum Discussion
Dates are friggin weird in QB and nulls.
try:
If(ToText([Sub Payroll - Actual Finish Date])=null, //Some Status Field,"Completed")
You don't need a status field for the true condition but it may be better to add text so you know to review that record.
Ideally, this sounds like a Formula-Checkbox rather than Formula-Text. Maybe better to just use that and change the string to just TRUE for easier filtering
------------------------------
G.Macri G.Macri
------------------------------
try:
If(ToText([Sub Payroll - Actual Finish Date])=null, //Some Status Field,"Completed")
You don't need a status field for the true condition but it may be better to add text so you know to review that record.
Ideally, this sounds like a Formula-Checkbox rather than Formula-Text. Maybe better to just use that and change the string to just TRUE for easier filtering
------------------------------
G.Macri G.Macri
------------------------------