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

Is there a way to tally (add up) and display customer fields in Trello?

I am collecting numerical information in the cards, and want to be able to add them up to a total without having to export the data? 

 

Has anyone figured out a way to do this?

 

Thank you!

2 answers

0 votes
Iain Dooley Community Leader May 03, 2019

@Tim Boyle as far as I know, the Butler power up doesn't have the ability to loop through all cards in a list and sum the values for a given custom field although @Oscar_Triscon or @Katrin Anger would be able to confirm if that's the case.

In the meantime this Trellinator function would set the name of lists to "List Name (XX)" where (XX) is the SUM of all values in the custom field "Something to Tally" whenever a card was moved (it will update the names of the list the card was moved out of as well as the list the card was moved into):

https://gist.github.com/iaindooley/86df7a00c2052c9af7cfad948244a9a5

Obviously you might need to tweak that to suit your specific use case. You can see more about Trellinator here:

https://community.atlassian.com/t5/Marketplace-Apps-articles/Introducing-Trellinator-Automate-Trello-with-Google-Apps-Script/ba-p/925271

0 votes
Katrin Anger Community Leader May 03, 2019

@Tim Boyle 

Hi Tim, yes there is a way to calculate numeric custom fields. Actually, there are two ways.

The first, is setting up a new custom fields that stores the calculated value. And the action for this could look like this:

Bildschirmfoto 2019-05-03 um 11.11.20.png

 

Alternatively, you could store the calculated value in either the description of a card or in a comment.

Setting up the command's action would look like this:

(I made use of only one example here)

Bildschirmfoto 2019-05-03 um 11.10.46.png

 

You could even send the result of the calculation off by email (if you have a paid account). And a fourth way would be by using user variables, but that's probably the least comfortable one.

 

Does that help?

Iain Dooley Community Leader May 03, 2019

@Katrin Anger that would sum the value of fields on an individual card though... My read of Tim's requirement was to take the value of a field that occurs on multiple cards and present the total.

Could you trigger when a custom field is modified, fetch a "total" card with the current total in it and add the new value set on the card?

Katrin Anger Community Leader May 03, 2019

@Tim Boyle @Iain Dooley 

If that's really Tim's requirement than I currently see no other way than setting up user variables on this.

One could add values to card variables, and use them in a calculation.

Even if the value in the custom field changes and the card variable is modified accordingly, the calculation should work.

Like Alberto J. Azevedo likes this

@Katrin Anger Could you give an example of what this would look like? I'm also trying to do what Tim requested. Thanks!

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Trello

Develop a new Habit during Lockdown

If you had to thrive a new habit during a lockdown, what would it be? Trello

1,616 views 15 6
Read article

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