Discussions

 View Only
  • 1.  Not IsNull

    Posted 09-20-2019 13:35
    If date field is not empty, return "COMPLETED" in text field.

    If [Sub Payroll - Actual Finish Date] is empty
    [Status Completed]=COMPLETED

    ------------------------------
    Lynne8817 Lynne8817
    ------------------------------


  • 2.  RE: Not IsNull

    Posted 09-20-2019 13:41
    Edited by Mark Shnier (Your Quickbase Coach) 09-20-2019 15:57
    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
    ------------------------------



  • 3.  RE: Not IsNull

    Posted 09-20-2019 15:32
    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.


  • 4.  RE: Not IsNull

    Posted 09-20-2019 15:41
    Edited by Giuseppe Macri 09-20-2019 15:42
    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
    ------------------------------