Round Up Function

I’m trying to figure out how to add a calculation similar to the ROUNDUP function in Excel. I see that we have ROUND, but that can go down if the number is .49 or lower. The use case is calculating the number of paint cans based on square feet. We can’t round down in this situation as then there won’t be enough paint. So if the calculation is estimating 10.2 cans of paint, we need to round it up to 11.

Hi @peterbujok ,


Have another field that is called INT cans, so when you save to the collection, this field will be saved as INT(cans).

Later you can do update action to cans as INT cans+1 if cans > INT cans

Thank you, that seems like a decent workaround, hopefully we get some more Excel style functions in the future so we can create more direct calculations.

1 Like

This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.