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,455,720
Community Members
 
Community Events
175
Community Groups

Math operations in Trello Automation

Is it possible to use math operations in Trello rules?

For example I want to select the Nth item in a list randomly so I perform some math on the current time of day to generate a not so random number. There is a topic referencing the Nth checklist but not Nth checklist item so it is unclear if the same logic would apply.

1 answer

1 accepted

0 votes
Answer accepted
Hannah Morgan Community Leader Jun 15, 2022

Hi @Jesse Lopes ! Welcome to the community :) it is possible to create calculations with butler and custom fields (see here under "Custom field arithmetic"). Are you able to explain a bit more how you see the calculation working? 

Suppose I have a list of items numbered from 1 to N. It is possible to select the specific checklist item by "#) {*}". I don't expect for a function like rand() to be present and it hasn't shown to work in fields I have tested so far. So to generate a random integer I could instead use the current {yeardaynumber} and some math with either the modulus, ceiling, floor or truncate math functions. Further to this it is not clear in what format or fields an arithmetic expression is handled as math rather than plain text beside the custom field example.

Hannah Morgan Community Leader Jun 16, 2022

I believe you can use number and date custom fields in your custom field equations. So yeah, if you're looking at using a random number in your calculation, you could use a variable such as the one you mentioned, or take the checklist item name value and add it to the custom field. I'm not sure how the latter would work in terms of selecting a random checklist item or what the trigger would be in this case. 

Is it not possible to do arithmetic expressions outside of a custom field operation? I have tried a few arrangements of the curly braces around or next to math operations and have not yet yielded a value. Are you implying the values would have to be stored or set into a custom field in order to perform any math operations?

Hannah Morgan Community Leader Jun 19, 2022

AFAIK, butler can only do calculations with custom fields, so yes, you would need the values to be held within custom fields in order to create a calculation.

Thank you for your insight. It seems the automation route I was seeking is too complex for the Butler and will need to be done manually.

Suggest an answer

Log in or Sign up to answer
TAGS

Atlassian Community Events