Re: Not IsNull
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
------------------------------