Am I right in thinking Bubble calculations can’t include brackets?
How would I enter a formula like this without brackets?
=B4+((B4-B5)/3)
Yes, standard Bubble doesn’t have a function for brackets, neither does it follow standard order of operations - all equations in bubble are read left to right and done in the order they appear.
So for more complex equations that would normally use brackets you have 3 options…
-
Re-order your formula so it works from left to right. This is not always possible but in your example above it would be: B4-B5/3+B4
-
Use custom states to temporarily store the values of each part of the equation, then do the calculations on those values. e.g. set custom state x’s value to B4-B5, set custom state y’s value to custom state x’s value/3, then calculate B4+custom state y’s value.
-
I think there are some plugins that let you use brackets (I’m not certain though) so maybe look into some of those.
3 Likes
Great reply Adam and thanks for three solutions 
After using brackets for decades it is hard to get my head around not using them.
Option 1 will do it for this time, but if I have any more complex ones to do, which I am sure I will, then it looks like option 2 will be the way to go.
Thanks Adam.
1 Like
And here is a new free plugin
Hi all - We recently released an experimental features UI that has a development version of parentheses. Learn more here! Hope you all have the opportunity to start playing around with it and help us iterate to make it better!