Percentage of Total Tasked Complete
Options
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!
