Formula to calculate Completion % based upon STATUS not time


What formula can I use to calculate if a task is Complete or not here?

My overall goal is to have the Project Plan calculate the % complete based upon the actual Status column vs the Start/End Dates.

I am essentially taking the PMO Template set and re-doing it to be based upon a Due Date we can set per task vs following the Start/End Dates with Duration and Predecessors.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!