Hi I'm trying to set a custom field so it multiplies the value of a different custom field by .06. Addition (+) works, but multiplication (*) doesn't.
Thanks!
- Rich
Hi Rich,
Unfortunately it isn't possible to do this sort of formula with the Custom Fields Power-up. In that case, I'd recommend that you try out the SmartFileds Power-up which allows you to do calculations with the values in your fields.
Have a great week!
Ryan
On this Butler Help page:
https://help.trello.com/article/1160-custom-field-variables#custom-field-arithmetic
...it says:
When setting the "Number" custom field, you can perform basic arithmetic operations such as addition, subtraction, multiplication, and division. You can also use numeric constants and parentheses to group arithmetic expressions.
But unfortunately it doesnt list examples
How do I multiply? I try to do this:
when custom field "SUM" is checked, set custom field "TOTAL" to "({{%Field 1}} * 4.2) + ({{%Field 2}} * 2.5)"
But it doesnt work?
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.