Forum Discussion

BobFaulk's avatar
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:
      (Today()-[Max Activity Date])<[Activities Due Every (x) Days],
        "Activities Due"

    Ryan Pflederer