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

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

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

Can you generate a sum of numeric custom fields on all cards on the list?

I am new to Trello. I added some numeric custom fields to cards. Is there a way to display on a list the sum of values for each of the cards on that list?

Example:

I have a numeric custom field called Count

I have a List called "M&M's in a bowl" with three cards:

  • Name = Red, Count = 4
  • Name = Yellow, Count = 1
  • Name = Brown, Count = 5

Can I show a total of 10 for the "M&M's in a bowl" list?

4 answers

3 accepted

@Rachel Beach  The count field would be a custom field. https://help.trello.com/article/1161-custom-field-arithmetic
The challenge you will face will be iterate through the list and be able to store the results each step of the way. You can use either a label, description field, ..etc.
I have a dashboard application which looks at any numeric custom field on a board or list and gives you count, sum, average, Min and Max in a table. I have plans to convert for use as an generic add on to Butler. Unfortunately I am exceeded my quota to show you a demo. Note also getting custom field via a Lookup command will probably be a challenge. Using Find move the current card point such that storing the sub totals will be a challenge. My will have to be on {triggercarddescription}

Consider using Smartfields Power Up. 

Update: Completed and tested but because I exceeded my Butler I ran it on a Team board...you have the imagine the output you see below as being available to your Butler commands e.g if you need the average it will be {httpresponse.average}. There are probably other ways to do this but my objective is to do work in which native Trello cannot do and be able to integrate with Butler it is available to all users.

Screen Shot 2020-08-04 at 12.46.43 PM.png

0 votes
Answer accepted
Iain Dooley Community Leader Aug 03, 2020

@Rachel Beach this Trellinator function sums the "Num" field in each list and adds that number to the list name. If the list name already has a number, it updates it:

https://gist.github.com/iaindooley/2464ce050244fcb21565cd839d2e6201

You can try this out here:

https://app.benkobot.com/

Once you authenticate you can copy/paste the code in to run it, you'll need to update the name of the board from "TEST" to whatever your actual board name is.

You could use a similar function executed daily or when cards are moved. You can see more about how to set up Trellinator here:

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

Unfortunately BenkoBot doesn't do notification handling or scheduled commands yet.

0 votes
Answer accepted

The Number Stat powerup might be worth a look.

Requires Gold or up though, as it also requires the base Custom Field powerup.

Thank you all for your suggestions!

Suggest an answer

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

📹 What is Trello?

Hello Community!  My name is Brittany Joiner and I am a Trello enthusiast and Atlassian Community Leader. I'll be sharing with you a series of videos with my top tips on how to best use Trello...

846 views 14 30
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