Automation with conditional trigger

[Francesco Baldani]

Looking for an automation that adds a label if the task has been completed on time or not.

Like, if completed before the deadline (due date) add "ON TIME" and if completed after the deadline (due time) add "LATE".

[Stanley Duback · Accepted solution]

Hey Francesco,

What type of project and set up are you using? Jira Software/Service Management/ Work Management

Are you using Jira Cloud? 

Also how are you currently judging an issue to determine if its on time? Completed before sprint date? Completed before SLA is lapsed? etc.

[Francesco Baldani]

Hi, Sorry I thought the platform was said...

I am using a simple Trello board. The task completion is mostly for an aftermath analysis, as this is to direct the activities of a design office. Therefore I don't dare call it SLA (except in particular cases).

Anyway, my reference date is the due date. When completed I added a personalized field that adds a completion date/time timestamp.

With these two pieces of information, the planned due date and the actual completion date, I can simply obtain OTD (On Time Delivery) statistics...

Eventually what I am looking for is a conditional trigger (classical if/elseif) or two "when" conditions:

- if the completion date is <= the due date --> add a label (or whatever field) "ON TIME" elseif add "LATE

or the second option:

- when the completion date is <= the due date --> add "ON TIME"

- when the completion date is > the due date --> add "LATE"

I hope this clarifies my request.

[Stanley Duback]

I would try to approach this in simplest form possible, since you cannot write a custom script to do a conditional trigger.

All cards are on time unless when closed and "with a overdue due date" 

If overdue then complete action, then everything else can be assumed on time.



If helpful you could have a separate automation that runs when a card is created that edits the custom field to say "ON TIME"