# % complete in a row

Options
✭✭✭✭✭
edited 12/09/19

Hi, i am looking for some help.

I have a project which has 360 locations, resulting in 360 rows. i have 8 status columns in each row. is there a formula that will replicate a % by counting each status column that is complete and making that =12.5 .

So for example all 8 status are complete this = 100, 6 status complete would = 75.

hopefully some help is out there?

thank you

Dave

Tags:

• ✭✭✭✭✭✭
Options

Give this a try...

=COUNTIFS([Status Column 1]:[Status Column 8], "Complete") * 12.5 + "%"

or

=COUNTIFS([Status Column 1]:[Status Column 8], "Complete") * .125

and then format the column as a percentage.

You'll just need to change the column names to whatever you're using along with the text "Complete".

Remember... when using "Text" to denote a specific text, it is case sensitive. So if your status is Complete and you have "complete" in your formula (or even "Completed"), it won't give you the results you're looking for.

• ✭✭✭✭✭
Options

Hi Paul,

That has worked a treat, thank you so much for taking the time to help.

Really appreciated

Dave

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!