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
Check out the Formula Handbook template!