How to calculate total percent completion only within rows that meet a specific criteria?
I have developed a project schedule that is detailed and has information that should not be shared with the client. In order to provide the client with a summary view, I am using a checkbox column to mark the rows that should be client facing, and pulling them to be shown separately on a report. In parallel, I developed a dashboard that includes the overall project percentage completion (calculated automatically within the sheet), based on the detailed information from the comprehensive internal schedule.
My question is, what is the most efficient way to calculate the total project percentage completion only within the rows that are client facing (that have the "Client Facing" checkbox column marked)?
I would like to include that data on a separate client facing dashboard, but it would have to align with the level of information they have access to within the other sheets/reports. Thank you in advance.