How to Calculate Percent Complete in Sheet Summary
My sheet is used as a task checklist for projects. It currently has a 'Status' column for each Child task with 4 dropdowns (Not Started, In Process, Complete, N/A).
I am trying to create a percentage in Sheet Summary that calculates the number of fields that are marked 'Complete' in the selected cells.
Pulled this formula off another post, but can't seem to get it to work;
=iferror(countif(Column2:Column29, CONTAINS("COMPLETE"))/ countif(Column2:Column29, not(CONTAINS("N/A"), Column2:Column29, "<>"),"")