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%
- Add a % and 2. No decimals.
Can you help.
Answers
-
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(.........................)) + "%"
-
Hi @Paul Newcome ,
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
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 351 Global Discussions
- 198 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 443 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!