Formula to calculate % Complete based on amount of completed tasks vs total tasks


Hello Everyone,

For a new project I am working on, i'd like to use a formula that calculates the % complete of a project based on the total amount of tasks, and the tasked marked as complete in the status column.

In my sheet summary, I have a COUNT formula that has totaled all tasks, and all tasks marked as complete but I am not sure of the next step. Any help would be much appreciated!!

Thank you!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!