Rounded Percent
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)
Answers
-
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
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!