How to calculate days past original due date?

2025年01月24日 00:41

One of our product teams is wanting to monitor and report on tasks that are X days past their ORIGINAL assigned due dates

Given that I have a set of active tasks with due dates
AND those tasks are OVERDUE (past their ORIGINAL due dates)
AND new due dates have been assigned
THEN I'd like to see how many days those tasks are past their ORIGINAL due dates

A solution I've tested is

Creating a Original Due Date formula field that copies the assigned due date of the task
Once tasks are assigned their first due dates, duplicate them and copy the Original Due Date field value
Creating another custom field for Days Past Original Due Date that gives me the days since that day

Not a great solution since:

duplicates the number of tasks
does not reflect the original task's current status
does not reflect the original task's assignee (since duplicating the assignee in the new task would be confusing for work execution)

Any ideas team?

2件のコメント

Pietro Poli

2025年01月24日 13:50

Hi Luis Cardenas,
I have the same situation and we did it this way.

On all tasks we have 3 different custom fields:

Due date Original (is the date assigned to a task as first due date)
Number of Changes (how many changes we have made in due date)
Days Difference (a formula that makes a difference between Due date and Due Date original)

So how does it work:

I create a task and assign a due date
Upon creation I check whether the "Due date Original" has a value or not
If it has no value then I copy the Due Date into "Due date Original" and Add +1 to Number of Changes
If instead it is already valued I Add +1 to Number of Changes

This way I get only 1 task that has this information:

You have to do it with the API or with Wrike Integrate, you have no way to do it with the current automations present in Wrike.

Luis Cardenas

2025年01月24日 21:05

Pietro Poli thanks for responding.

Interesting, so for the how it works, are 2-4 manual inputs?

I create a task and assign a due date
Upon creation I check whether the "Due date Original" has a value or not
If it has no value then I copy the Due Date into "Due date Original" and Add +1 to Number of Changes
If instead it is already valued I Add +1 to Number of Changes

What API or Wrike Integrate tool did you use?

Thanks in advance!

Folllowing List for Post: How to calculate days past original due date?
[this list is visible for admins and agents only]

トップ

今後のライブセッション