Skip to main content
Question

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

  • April 20, 2023
  • 0 replies
  • 153 views

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
------------------------------
This topic has been closed for replies.

Forum|alt.badge.img+3

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
------------------------------