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

Butler: rounding float values

When using simple arithmetic equations with Trello butler, is it possible to round a resulting float value into an integer or at least a float with fewer decimals?

Example:

Custom fields Effort and Impact with values 3 and 10 respectively.

Butler equation:

set custom field "Priority" to "{{%Impact}} / {{%Effort}}"

This sets Priority to 3.3333333333333335. Is it possible to have the result somehow formatted to 3 or 3.33?

1 answer

1 accepted

1 vote
Answer accepted
Lara Atlassian Team Feb 09, 2021

Hi Kartturi,

Thanks for reaching out!

At the moment, there isn't a way to round float values using Custom Field arithmetic.

If it helps at all, when you view the card on the board, it'll show the Priority field as 3.333:

Image 2021-02-10 at 12.59.54 pm.png

That said, I understand how this could be helpful, so I've flagged this as a feature request with the product team – let me know if there's any additional info you'd like for me to send their way!

If you're curious about how our team decides on what requests we work on, this article gives some insight into that process: http://help.trello.com/article/724-submitting-feature-requests-for-trello. We've also published a blog post with more detailed and visual information here: https://blog.trello.com/feature-requests-unite-support-and-product

If you'd like to see our latest features and releases you can take a look at our dev board at http://www.trello.com/dev. Our mobile boards are available at https://trello.com/b/5tj4qAvo/trello-ios-app and https://trello.com/b/ud59t1fL/trello-android-app.

All the best,

Lara
The Trello Team

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,635 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