The context: We are a construction company that uses a Monday board to track progress on our projects. Each project will have some combination of systems (e.g. shingles, gutters, pavers, etc.), but each project is different. Some projects may have all system types that we work on while other projects only have one system.
We use a progress tracking column to provide an overall project progress percentage for each project. This column reads from the status columns for each system. When we mark the system as “Done”, that column is added to our progress tracker.
The problem: The progress tracker only provides an accurate percentage if we are using all systems for every project. If we are not using all systems on a project then the progress tracker will never hit 100%. Our workaround for this is to have the progress tracker accept two status as “Done”: it accepts both “Completed” and “N/A”. But it still doesn’t give an accurate percentage. If we are not using all systems, then before we begin any work the tracker will show the percentage representing the systems that are “N/A”.
Proposed solution: We would like the progress tracker to conditionally include status columns based on the status. If the status is “N/A”, do not include it in the calculation. If the status is “Complete” then include as completed. If the status is anything else, include as not completed.