Formula for "Overdue" or "On Time" based on 'Status' and 'Due Date'

Platform discussions
1

Hi,

Pretty simple request, but struggling to find guidance.

I want to create a formula which gives me a value of either Overdue or On Time based on an Overall status column and due date.

The logic would be as follows:

If OVERALL STATUS is not DONE and DUE DATE isin the past generate value OVERDUE

2

This should work. Obviously update the dynamic values according to your column names.

IF(
    AND(
        NOT({Overall Status}="Done"),
        FORMAT_DATE(
            TODAY(),
            "YYYY-MM-DD"
        )>
        FORMAT_DATE(
            {Due Date},
            "YYYY-MM-DD"
        )
    ),
    "Overdue",
    "On Time"
)
3

Maybe this isn’t what you’re after, but Monday does have a built-in feature for deadlines that shows when items are overdue. See this article for more info.

Some example images:
image

image
image1493Ă—296 12.6 KB

1 Like
4

Thanks Francis, unfortunately I can’t get this to work. Perhaps that’s just me, but just get errors when trying to run

5

Calum’s suggestion is also great!

Feel free to share a screenshot of the formula and your board and I’d be happy to take a look. You’ve most likely made a syntax error when implementing the formula.

1 Like
6

Hiya, I use a timeline column, date column plus some formula columns.

The date column has an automation to set the completed date to the day the status changes to done.

The first formula column shows if the task was completed early or late.
IF({Completed Date}=“”,“N/A”,DAYS({Timeline#End},{Completed Date}))

The second formula column tells me if the task is pending/overdue or if it was completed on time or late.
IF({Timeline}=“”,“Pending”,If({Status}=“Done”,If({Completed Early/Late}<0,“Done Overdue”,“Done On Time”),If(DAYS(TODAY(),{Timeline#End})<0,“Pending”,If(rounddown(DAYS(TODAY(),{Timeline#End}),0)=0,“Due Today”,“Overdue”))))

I’m pretty sure I got all this from a help article but can’t find it now sorry!