How to make the number in my string + formula display as a percent?
Options
I am having an issue where i have created a string plus a formula (="Percentage Complete " + COUNTIFS(Complete2:Complete11, =1) / 10 ) is there any way i can get the number that is being counted in my formula to read as a percent? i tried clicking the percent symbol while having the cell selected but since the string is attached to the number it isnt converting it
Best Answer
-
Try this...
="Percentage Complete " + ((COUNTIFS(Complete2:Complete11, =1) / 10) * 100) + "%"
Answers
-
Try this...
="Percentage Complete " + ((COUNTIFS(Complete2:Complete11, =1) / 10) * 100) + "%"
-
Thank you, That worked
-
Happy to help. 👍️
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!