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,293,467
Community Members
 
Community Events
165
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
Community showcase
Posted in Trello

Taco Tuesday: New years' resolutions with Trello

Congratulations to @Laura Holton , our latest winner of Taco Tuesday! And thanks to @Kristján Geir Mathiesen for sharing the picture of Taco having fun with his new friend  B...

2,265 views 27 40
Join discussion

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