Convert to Percent


Hi Team, I have a formuale in one sheet cell that is bring in a value from another sheet through Index/Collect.

I need to convert the transported value into percentage.

Eg - =INDEX(COLLECT({Profit Margin}, {Program Name}, CONTAINS([Program Name]@row, @cell)), 1) = 50.00

I need to convert this to 50%

  1. Add a % and 2. No decimals.

Can you help.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!