Thanks @MadeFreshDesign! This doesn’t totally solve the problem, but it might offer a good work-around for the time being. And it’s nice to know about the ability to use if else like code inside of the calculation. (I don’t think the documentation says that… unless I’m wrong.)
It sounds like Daniele might be working on something along the lines of what I was originally suggesting.