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%.
Comments
-
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Β
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!