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

Sum minutes and seconds of cards to list

Hi there,
I use Trello to organise a tv programme: every list is a episode, every card is a news. I would like to add minutes and seconds to every card and have a card on top of every list which sums times and gives me the exact time of the entire episode. So if an episode is too long I can move a card to the next one.

I've tried Smart Fields power up that does the same with numbers (not minutes and seconds).

Can you help? Thank you!

3 answers

0 votes
Iain Dooley Community Leader Mar 16, 2021

@Daniele Semeraro this Trellinator function would allow you to sum the minute and second values from a custom field value called "Time" whenever a card is moved into a list and set the name of the first card in the list to the sum:

https://gist.github.com/iaindooley/dcaa9d432bd5b7fbb6800bd16afa0a59

You can run it via Google Apps Script:

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

or via our BenkoBot platform as a "Listener":

https://app.benkobot.com/

@Daniele Semeraro this chrome extension might help: https://chrome.google.com/webstore/detail/ultimello-the-features-pa/hahbfgjfimnmogoinnenhheepfcphnmm

The idea would be to use a numerical custom field using the custom fields powerup, and the chrome extension would sum up the values from all the cards in each list. 

Thank you very much. The fact is that I don’t need to sum up regular numbers but time. For example 1:50 + 0:20 = 2:10

Thank you for your reply. Unfortunately I couldn’t find anything. Did you find something useful? Thank you. 

Suggest an answer

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

📹 Favorite Trello templates

Hello Community!  My name is Brittany Joiner and I am a Trello enthusiast and Atlassian Community Leader. In this video, I'll share my favorite Trello templates. Templates mentioned in ...

3,671 views 25 63
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