Forum Discussion

SarahGriffin's avatar
SarahGriffin
Qrew Member
4 years ago

Case/Date Formula

I'm trying to get this report formula field to only display a number if there is no [actual completion date] entered, but it has me stumped. Is there a trick for identifying any date entered? Thanks!

case([Actual Completion Date],
null, ([Feeder - FTTH Target Run Rate (Miles/Wk)]-[Adjusted Run Rate (Wkly)]),
date(<today()), null)

------------------------------
Sarah Griffin
------------------------------
Formulas and functions
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    4 years ago

    Try this. But I'm not sure what you were trying to do with the second part if the formula. 


    IF([IsNull(Actual Completion Date]),
     [Feeder - FTTH Target Run Rate (Miles/Wk)]-[Adjusted Run Rate (Wkly)])



    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------
    • SarahGriffin's avatar
      SarahGriffin
      Qrew Member
      4 years ago
      Worked like a charm, thanks Mark! I'm still working on expanding my formula knowledge. 


      Sarah Griffin
      Construction Program Supervisor
      mobile: 816.288.8011