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

Wendy Gray

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!!!!

David Joyeuse

Hi @Wendy Gray

Try this in both parent columns:

=COUNTIFS(CHILDREN();OR(@cell="Completed"; @cell="N/A")) / COUNT(CHILDREN([Main Column]@row))

Should do it.