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! ...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendTry 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
------------------------------
- Worked like a charm, thanks Mark! I'm still working on expanding my formula knowledge.
