How to write a formula that returns "Task Ovrdue" if a task is beyond (X) days

Question

HI, Thanks in advance,&nbsp;How do I write a formula that returns a "Current" or "Overdue" based on a field that tells how many days that task has to be performed and it has a Max activity date summary field, and a "Activities Due Every (x) Days" field.Today()-[Max Activity Date]&gt;([Activities Due Every (x) Days]),"Current","Activities Due"))That was the best I could figure out. Thanks again------------------------------Bob Faulk------------------------------

ryanpflederer3 · Answer

Hi Bob!You're so close! Give this a try:If(&nbsp; (Today()-[Max Activity Date])&lt;[Activities Due Every (x) Days],&nbsp; &nbsp; "Current",&nbsp; &nbsp; "Activities Due")------------------------------Ryan Pflederer------------------------------

Forum Discussion

How to write a formula that returns "Task Ovrdue" if a task is beyond (X) days