Task overdue help
I need help with my current formula. Right now, it returns "OVERDUE" if a report is not presented in time. The issue is that I need the Overdue to not populate if a date is in the "Date report pres...
Forum Discussion
I made these fields
Date fields :Report Due Date, Date report presented, Report Extension Due
Text, Multiple Choice field:Will a report be prepared? ( options Yes, No)
Formula Text field: warning
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]),
"OVERDUE"," " )
The only change made to your warning field is "Yes" vs. "yes" and added the colorization as an option to a report: If([warning]="OVERDUE","pink")
Date fields :Report Due Date, Date report presented, Report Extension Due
Text, Multiple Choice field:Will a report be prepared? ( options Yes, No)
Formula Text field: warning
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]),
"OVERDUE"," " )
The only change made to your warning field is "Yes" vs. "yes" and added the colorization as an option to a report: If([warning]="OVERDUE","pink")