How to make the number in my string + formula display as a percent?


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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!