% Complete (Showing as a number instead of %age)


The rolled up %Complete is showing up as a number (image attached), even when the child items are entered in %age.

How to convert the parent % Complete value to show up as % instead of number?

Thank you in advanced.


  • John Jonassen
    John Jonassen ✭✭✭✭

    The % Complete column is a simple Text/Number formatted column, so you should be able to just highlight the entire %Complete column (maybe make sure that all of your rows are showing, rather than minimized at each Parent row) and then hit the % Percentage Format button up at the top.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!