Rounded Percent

Desertbird
Desertbird ✭✭
edited 03/10/23 in Formulas and Functions

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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!