NEW FORMULA REQUEST: ROUNDUP and ROUNDOWN

Under Review

Description: For quantities of accessories tied to parent items that are measured in linear feet vs. count, we need to have a function of "ROUNDUP" and "ROUNDOWN" which as the name says will round up or round down to the nearest whole number (if you want to have decimals perhaps have that as an added feature, but please have whole numbers as the default".

👍2

Lorin Allred zzTakeoff5h 38m

Hey Alan-Mark, thank you for the feature request! We have the "roundup" function (when used in formulas, type it all lowercase), but not the "rounddown" function. I will pass this request along to the dev team.

By default, when using the roundup function, we round to the nearest whole number, but you can change the rounding with the second parameter. For example, to round to the nearest 2 decimals, your function would be "roundup(4.125, 0.01)", which would result in 4.13.

You must be logged in to post replies. If you don't have an account you can signup here.