# How to I calculate percentage progress in sheet summary based on status?

Options
✭✭
edited 06/05/23

How to I calculate percentage progress in sheet summary based on status?

Tags:

## Answers

• ✭✭✭✭✭✭
edited 06/05/23
Options

You would just need to do some nested IF statements. Example below:

=IF(Status@row = "Not Started", "0%", IF(Status@row = "In Progress", "50%", IF(Status@row = "Complete", "100%")))

Edit: I just re-read your post and you wanted it for the Summary Sheet. It would work the same way based on the Status cell you have in your Summary sheet. Just replace the Status@row with the cell in your summary sheet that has the project status.

Jonathan Sanders, CSM

"Change is always scary because it is unknown, but facing the unknown is what makes us stronger."

• ✭✭
Options

@Kleerfyre It didn't work. Attached is the ss of my sheet summary. So my goal is to to get the percentage by status.

I used percentile but seems not correct. Below data are just initial.

• ✭✭✭✭✭
Options

Maybe try using "0", "0.5" and "1" and then format the column as a percentage ?

• ✭✭✭✭✭✭
Options

What are the numbers under the Value, Value 2, Value 3? Are they counts of tasks with the associated Status? From what you are showing to what you are asking, it isn't lining up for me. Please let me know what you are aiming for based on the most recent screen shots.

Jonathan Sanders, CSM

"Change is always scary because it is unknown, but facing the unknown is what makes us stronger."

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!