Calculating Project Completion status using text via sheet summary

Hi all,

I am trying to calculate the overall completion of the project based off of trying to calculate the number of tasks with "Completed" as a status, dividing it by the total number of statuses in the "Status" column. I can't seem to figure out the formula to give me that percent. Here is what I am using; HELP!:

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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!