SarahGriffin
4 years agoQrew Member
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
------------------------------
case([Actual Completion Date],
null, ([Feeder - FTTH Target Run Rate (Miles/Wk)]-[Adjusted Run Rate (Wkly)]),
date(<today()), null)
------------------------------
Sarah Griffin
------------------------------