How to calculate percentage done automatically

Diego Casillas Zaragoza

Hello, in the picture below, I am trying to calculate the percentage done based on how many columns have the check mark on them.

Is that possible?

Michael Culley

You can do =countif([DA Line]@row:[DTF Line]@row,1)/count([DA Line]@row:[DTF Line]@row)

Then highlight the column and click on the % button.

Michael Culley

You can do =countif([DA Line]@row:[DTF Line]@row,1)/count([DA Line]@row:[DTF Line]@row)

Then highlight the column and click on the % button.

Diego Casillas Zaragoza

That was perfect! Thank you very much