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
MarkShnier__You
Qrew Legend
Qrew LegendTry 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
------------------------------
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
------------------------------
If(not IsNull([Sub Payroll - Actual Finish Date]), "COMPLETED")
There were some extra characters and one of the parenthesis was not closed. Just figured since the poster was so lost on this formula initially they may not know how to fix that too.
There were some extra characters and one of the parenthesis was not closed. Just figured since the poster was so lost on this formula initially they may not know how to fix that too.