# 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.

• ✭✭✭✭✭✭

You can use the column formatting (percentage format) which is one of the last few icons in the toolbar (expand the toolbar if you see ...).

• ✭✭✭✭✭✭

Thank you. Is there any other way wherein the output of formuale converts to percentile

• ✭✭✭✭✭✭

You would wrap the whole thing in a ROUND function then add the % symbol, but this will convert it into a text string that cannot be used as a number for further calculations.

=ROUND(INDEX(.........................)) + "%"

• This is robert again and wanted to get further assistance for the conversion to percentage of the values i have.

As you could see below

overall issue rows are 173 and out that i have 171 completed and 2 not completed i wanted to get a formula to do this as iam facing difficulty for the same.

Thanks

Rob.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!