Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

% progress between custom creation date & due date automatically updated

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

@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.

thanks, this is what I feared!

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

@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
Community showcase
Posted in Trello

Taco Tuesday: New years' resolutions with Trello

Congratulations to @Laura Holton , our latest winner of Taco Tuesday! And thanks to @Kristjan Geir Mathiesen - Origo for sharing the picture of Taco having fun with his new friend...

517 views 19 20
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you