Making Row Percentage

ESN

HI,

Very new to smartsheet

Working off Free account

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?

dojones

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