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