Rounding for Formula

Would be useful to have formula column with ability to round to certain decimal place, or whole number. Use often for things like cost / SF, but no ability that I can find to round to two decimal places.

Hi Jessica,

What about the ROUND function?

ROUND({Column},2) => 2 decimals
ROUND({Column}) => No decimals

What if we could break free of the Formula column and write formulas that update any type of columns? What if a formula could update multiple columns at once? This is possible with the Advanced Formula Booster app.

When making a formula using multiple column values, I could not get the round function to work. Gives a red exclamation point error sign. I found a work around on the forum to use the TEXT function, which rounds to a whole number. But sometimes I’d like to have the option to round to two decimal places for currency values.

You should post your formula and the values that make it fail and indicate which type of column for each values, because it should work.