% complete in a row

dave.mcpherson56751
dave.mcpherson56751 ✭✭✭✭✭
edited 12/09/19 in Formulas and Functions

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:

Comments

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    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.

  • dave.mcpherson56751
    dave.mcpherson56751 ✭✭✭✭✭

    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!