Task overdue help

Question

I need help with my current formula.&nbsp; Right now, it returns "OVERDUE" if a report is not presented in time.&nbsp; The issue is that I need the Overdue to not populate if a date is in the "Date report presented" field, even if it is past the due date or extension date.&nbsp; Below is my current formula:Thanks!If([Will a report be prepared?]="yes" and(IsNull([Date report presented])) and (IsNull([Report Extension Due]) and Today() &gt;[Report Due Date]) or (not IsNull([Report Extension Due]) and Today()&gt; [report Extension Due]),&nbsp; "&lt;span style=\"color:#ff0707; font-weight:bold\"&gt;"&amp;"OVERDUE"&amp;"&lt;/span&gt;"," "// end if)

lisasell1 · Answer

I made these fields&nbsp;Date fields :Report Due Date, Date report presented, Report Extension DueText, Multiple Choice field:Will a report be prepared? ( options Yes, No)Formula Text field: warningIf([Will a report be prepared?]="Yes" and(IsNull([Date report presented])) and(IsNull([Report Extension Due]) and Today() &gt;[Report Due Date]) or (not IsNull([Report Extension Due]) and Today()&gt; [Report Extension Due]),&nbsp;"OVERDUE"," " )The only change made to your warning field is "Yes" vs. "yes" and added the colorization as an option to a report:&nbsp;If([warning]="OVERDUE","pink")

angelabowman · Answer

thank you, but I still cant get it to work 100%  properly.&nbsp; If the report was presented late or on the due date , it still  shows overdue.&nbsp; If you put a date of 11/7 in the first, does yours still  show overdue?

lisasell1 · Answer

Sorry - I didn't consider 'Today'. I made an addition to your original formula with the last line:

If(

[Will a report be prepared?]="Yes" and

(IsNull([Date report presented])) and (IsNull([Report Extension Due]) and Today() >[Report Due Date]) or

(not IsNull([Report Extension Due]) and Today()> [Report Extension Due]) or

[Date report presented] > Today() and [Date report presented] > [Report Due Date],

"OVERDUE"," " )

angelabowman · Answer

Thanks Lisa...&nbsp; I guess I might have to rethink this as it's still not working for me:(

quickbasecoachd · Answer

Try thisIF([Will a report be prepared?]&lt;&gt;"Yes", "",&nbsp; // no reported needed then nullnot isnull([Date report presented]),''",&nbsp; // report completed, so null// ok so if we get this far in the IF then we know we need a report&nbsp;// and it's not yet done// but are we overdue yet?Today()&lt; [Report Extension Due],"&lt;span style=\"color:#ff0707; font-weight:bold\"&gt;"&amp;"OVERDUE"&amp;"&lt;/span&gt;")

Forum Discussion

Task overdue help

Related Content

Reassigned multiple task

send notification for overdue task

Overdue Duration Formula most be positive # of Days

How to automate tasks?

Completed task button