Dashboard Error - Data Integrity
Ok....so, I go through the work of complex formulas and get to a place where I can count the number of Green, Yellow, Red, and Completed projects. When I attempt to either link that info to another sheet or use it in a chart for a dashboard, the data comes out differently. You can see here for instance, I should have one project in the "Red" but it isn't in the chart at all. Thoughts?