Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

% progress between custom creation date & due date automatically updated

Arthur Darde January 1, 2022

Hi there,

I've been unsuccessful in finding a way to calculate and then update on a regular basis (every hour for example) a field that would display the value

(Due date - Now)/(Due date - creation date) x 100.

=> this value will help me prioritize tasks based on the relative time remaining to complete the task.

For example : If I have 3 hours to complete two tasks, but one has been there since 24hours, the other since 5hours, then the former is much more urgent than the latter (at least in my usecase).

1 answer

0 votes
milynnus
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
January 2, 2022

@Arthur Darde 

This can be done with a cron bot that will run every hour to update, say a custom field. This will involve inspecting all cards with code and Trello api. Note that although this done via code, the plan entitlement will be consumed. I learnt this while running a asynchronous process to a update checklist via code.

Arthur Darde January 4, 2022

thanks, this is what I feared!

Arthur Darde January 4, 2022

But I still don't see how to create the formula between the custom fields

milynnus
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
January 4, 2022

@Arthur Darde 

Custom field arithmetic is quite limited. See :

https://help.trello.com/article/1160-custom-field-variables

the cron bot will have to handle the arithmetic since it involves dates, division and multiplication.

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events