Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,465,932
Community Members
 
Community Events
176
Community Groups

% 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

0 votes
milynnus Rising Star Jan 02, 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.

thanks, this is what I feared!

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

milynnus Rising Star Jan 04, 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

Atlassian Community Events