Formula for % Complete
Options
Safiya B
✭✭
Hello,
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?
Answers

Try removing the "A" from the end of "COUNTA" so that it is just "COUNT"
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!