Sheet Summary % Complete

Joey135
Joey135 ✭✭✭✭
edited 04/22/24 in Formulas and Functions

I am feeling silly that I can't get this to work. I want to get the % complete of my project based on those with the status of "Complete" divided by all columns that have text in it.

=COUNTIF(Status:Status, "Complete") / COUNTIF(Status:Status, ISTEXT(@cell))

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!