# Making Row Percentage

edited 09/03/24

HI,

Very new to smartsheet

Looking for help on how to show percentage between two columns.

First column called Project Status which has named stages of project Budget,Install,Lost etc 13 in total.

Second Column is called total which is cost of each project

I'm looking to show a column that shows the percentage of each Project Status in relation to the total cost eg this percentage is Budget vs this percentage was lost. Is there a way to create a column showing this?

• ✭✭✭✭

If I understand your question correctly, you could do it like this. I suggest putting the summary formulas in a separate summary sheet rather than in one sheet on every row as shown below but this will give you the formulas.

Total Cost: =SUM(Total:Total)

% of Total: =Total@row / [Total Cost]@row

Total by Status: =SUMIF([Project Status]:[Project Status], [Project Status]@row, Total:Total)

Status% of Total: =[Total by Status]@row / [Total Cost]@row

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!