Percentage of Total Tasked Complete

daniel.n.rose.ctr77221

Good afternoon everyone!

I am trying to format my "% Complete" column to auto populate when changes are made to my "Requirements Total" and "Requirements Complete" (i.e. If I have 10 requirements in my Requirements Total column and I have completed 5 in the requirements complete, which would make my "% Complete" column auto populate 50%.

Andrew Stewart

On the face of it, this is quite simple (so I might be missing something ).

Try the formula: 

=[Requirements Complete]@row/[Requirements Total]@row

In the % Complete column, format it with the % symbol  to show 20% rather than .2