How to remove decimals from a percentage formula with text before it?


I currently have the below formula:

="Completion: " + [Product Data]@row / [Units Sold]@row * 100 + "%"

The cell then shows "Completed: 4.05405%". However, I'd rather this be "4.05%".

Please can someone advise how I can fix this? Fairly new to Smartsheets so I'm still learning!

I've tried to click the 3 dots and remove the decimal spaces but it doesn't work.



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!