Formula for % Complete

Safiya B
Safiya B ✭✭
edited 06/02/23 in Formulas and Functions


I have a question on formulas. In the screen print below, I am trying to write a formula that counts the number of "Complete" amongst a list of other status' and gives me the overall % complete. I think the formula I've written isn't correct. Can you please assist on where I have gone wrong?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!