Hello, Trello newbie here. I want to calculate * the numerical difference between the due date & the date a card was added to the list. (the way I use the Board, this difference, is my on-time-delivery to the customer) * the numerical difference between 2 custom fields (both set as numerical fields) * the ratio of number of cards added to one board to the cards added to another board (which can be grouped by week or month) I could not find a way in Butler to do this (or most likely I dont know how to do it). Once I know this, I want to use it in a power-up (Reports by Screenly) to create a dashboard that shows my quality and on-time-delivery to the customer.

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Calculate dates & custom fields

Amit Soman_s10o17

Hello,
Trello newbie here.

I want to calculate

the numerical difference between the due date & the date a card was added to the list. (the way I use the Board, this difference, is my on-time-delivery to the customer)
the numerical difference between 2 custom fields (both set as numerical fields)
the ratio of number of cards added to one board to the cards added to another board (which can be grouped by week or month)

I could not find a way in Butler to do this (or most likely I dont know how to do it).

Once I know this, I want to use it in a power-up (Reports by Screenly) to create a dashboard that shows my quality and on-time-delivery to the customer.

Accepted answers

Vero Rivas

Hi @Amit Soman

Look at this posts, maybe can help you

https://help.trello.com/article/1159-arithmetic-in-date-variables

https://butlerfortrello.com/trello-custom-field-automation.html

https://help.trello.com/article/1161-custom-field-arithmetic

https://tech.trello.com/power-up-tutorial-part-one/

Cheers

All comments

Vero Rivas

Hi @Amit Soman

Look at this posts, maybe can help you

https://help.trello.com/article/1159-arithmetic-in-date-variables

https://butlerfortrello.com/trello-custom-field-automation.html

https://help.trello.com/article/1161-custom-field-arithmetic

https://tech.trello.com/power-up-tutorial-part-one/

Cheers

Amit Soman_s10o17

@Vero Rivas thank you. Looking thru it now

Vero Rivas

If this response has answered your question can you please mark it as accepted so that other users can see it is correct when searching for similar answers.

Thank you

Manjula Madineedi

Hi @Vero Rivas, I am looking if there is a way to calculate the difference between two date custom fields using Butler? Ex: I have 'Start Date' and 'Completion Date' as 2 custom fields and if I want to know the duration of the task, want to write a Butler rule which will calculate the difference of these 2 dates and return in another custom field of 'Task time'. Can you help?