% complete based on count of completed pieces

edited 12/09/19 in Formulas and Functions


I'm running a project where I want to report our the % completion of a sub task based on the # of pieces completed. I'm thinking I need to create a formula as the % of completion functionality looks at duration vs. actual amount of work completed. Can someone offer guidance? 

Smartsheet Formula Question.PNG


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!