Forum Discussion

BuildPro's avatar
BuildPro
Qrew Captain
6 years ago

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
------------------------------
Formulas and functions
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    6 years ago
    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
    ------------------------------
    • AustinK's avatar
      AustinK
      Qrew Commander
      6 years ago
      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.
  • GiuseppeMacri's avatar
    GiuseppeMacri
    Qrew Captain
    6 years ago
    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
    ------------------------------