Early, Delayed, On Time Status Formula

[cgrzybowski (Corey Grzybowski)]

I know this has worked for a single timeline (Formula for Overdue using timeline column) but is there a way to trigger a status depending on the difference between two separate timelines columns?

I currently track a baseline column for when I planned to have some piece of work completed within. Then I track an actual timeline for when the work is currently set for. I’d like to take the difference between the two timeline end dates to determine whether I’m going to deliver this item in this board earlier than the end date of the planned time (based on the difference in actual timeline end date) or later (Delayed) or if both end dates match (On Time). Is this possible? I’ve used the following formula before but I need help to extend it to my scenario.

IF(MULTIPLY(DAYS({Planned Timeline#End},TODAY()),-1)>0, “Delayed”, “On Time”)

Assuming this would get elaborated to fit what I’m trying to do. Thanks in advanced.

[JCorrell (Jim - The Monday Man)]

@cgrzybowski

Try this:
IF(DAYS({Actual Timeline#End}, {Planned Timeline#End}) > 0, "Delayed", IF(DAYS({Actual Timeline#End}, {Planned Timeline#End}) < 0, "Early", "On Time"))

---

Jim - The Monday Man
Column Magic - the magical columns toolbox app

[Valeriia.H (Valeriia)]

Hi @cgrzybowski

Also for calculating the time between the two separate timelines columns i recommend you to try Time in Status app which helps to track time the Item has spent in each workflow status easily. So you can monitor how fast the Item moves between statuses.
You’ll get user-friendly data on the board in a few seconds.

Also you will be able to track how much time your issue spends in each status and much more by generating:

• Time in Status Report
• Status Count Report
• Transition Count Report

And use charts to visualize your reports a sample of a certain number according to time range/item range, or a single item:

• Pie Charts
• Bar Charts
• Area Charts

The app is also available in the format of board integration.

Start the 14-days free trial to try it out for yourself and share your experience with us.

Hope you find this app helpful,
Valeriia