Forum Discussion

BobFaulk's avatar
BobFaulk
Qrew Member
2 years ago

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

HI, Thanks in advance,
 
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]>([Activities Due Every (x) Days]),"Current","Activities Due"))

That was the best I could figure out. Thanks again



------------------------------
Bob Faulk
------------------------------

1 Reply

  • Hi Bob!

    You're so close! Give this a try:
    If(
      (Today()-[Max Activity Date])<[Activities Due Every (x) Days],
        "Current",
        "Activities Due"
    )



    ------------------------------
    Ryan Pflederer
    ------------------------------