Not IsNull

Try this

IF(not IsNull([[Sub Payroll - Actual Finish Date]), "COMPLETED")


**** typo corrected above ****

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------

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