I am trying to create a % complete at the top of my progress column

I am trying to report out the % complete by category based on whether we are completed, or not. the column is a drop down column - I’m trying to consider “completed” and “N/A” as completed and "blank” and “in progress” as not completed.  so in the first column I would only be 36% completed - 4 out of 11. but in the last column i would be 100% completed. Can anyone help me? Thank you so much!!!!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!