Rounded Percent

Desertbird

Hello,

Hello I'm trying to get Smartsheet to round this formula 2 places passed the decimal. I have it in percentage format, but it still rounds to the whole number.

Formula:

=(AARP@row + BYOD@row + [No reason discount]@row + [Customer Satisfaction]@row + [Price match discount]@row) / ([Retail Sales]@row - Easypay@row)

Genevieve P.

Hi @Desertbird

Have you tried adjusting the decimal place by using the Formatting toolbar? You should be able to click on the column name, then select "Increase Decimal""

showing more data:

Let me know if that worked!

Cheers,

Genevieve