% complete in a row

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




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!