ContributionsMost RecentMost LikesSolutionsIf/Then Date Formula (Multi Conditions)I'm trying to create target serviceability dates, with multiple conditions, and it's seeming to only want to acknowledge the first portion of the logic. I am using relationship date fields, maybe that's where this is going left? I'm also going to need to change this for my actual serviceability dates, which uses similar logic. Your help is appreciated! If the DIA Due Date is after the Splicing Target Completion AND the DIA Received/Completed date is before the Splicing Target Completion - use Splicing Target completion If the DIA Due date is after the Splicing Target Completion AND the DIA Received/Complete date is Empty - use the DIA Due Date Otherwise - use the Splicing Target Completion If(ToText([Hut - DIA Due Date])>ToText([Splicing Target Completion Date]) and ToText([Hut - DIA Received/Complete])<ToText([Splicing Target Completion Date]),[Splicing Target Completion Date], If(ToText([Hut - DIA Due Date])>ToText([Splicing Target Completion Date]) and IsNull([Hut - DIA Received/Complete]), [Hut - DIA Due Date], [Splicing Target Completion Date])) ------------------------------ Sarah Griffin ------------------------------ Re: Case/Date Formula Worked like a charm, thanks Mark! I'm still working on expanding my formula knowledge. Sarah Griffin Construction Program Supervisor sarah.griffin@conexon.us mobile: 816.288.8011 Case/Date FormulaI'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 ------------------------------ Re: Offline Location Hi Mark! So I just tested my iPhone in airplane mode, via the QB app, and the address fields were there for manual input, but there was no option to grab the location. Use case is for crews in sometimes VERY rural areas, we really need a lat/long pin drop. Sarah Griffin Construction Program Supervisor sarah.griffin@conexon.us mobile: 816.288.8011 Offline LocationHiiii! I'm currently trying to transition a department in my company from Fulcrum to QB, the only issue I'm running into is capturing a location point while in offline mode. I'm told Fulcrum can pin a location even in no signal areas and then queue for later upload. Can someone explain this sorcery to me? Possibly suggest workarounds? Thanks in advance! ------------------------------ Sarah Griffin ------------------------------