Find the Percentage of the Total


I have 4 columns that I have added together in the 5th, Total column (using =sum formula). Each of the 4 columns is a single dropdown select (values: 1-10). I want to translate the Total into a percent in the Percentage column, so I thought if I took the total value and divided by 40 (the max amount) in the % column, I would get the percent, but that does not work.

Would appreciate any insights on this.


  • Sameer Karkhanis
    Sameer Karkhanis ✭✭✭✭✭✭

    Are you saying the formula in the Percentage column =Total@row/40 is not working? Make sure your Percentage column is text/number type and column is formatted to be "Percentage format" (use the formatting from the toolbar)

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!