I need testers for a project that started as a ticket item when I went through Wood Badge. My unit can't afford TroopMaster and I wanted something that when the scout sat down with me or the members of the board we could see what the scout had accomplished. Here I am five years later and now on the 20th revision and I have accidentally created a problem. On the Dashboard page I have is to where it checks to see how many requirements have been completed by seeing if there is an "A" in the field.The formula currently in use is: =IF(7-COUNTIF(Sheet#,"A")=
t#,"A")). The problem I created is that one of the fields it is looking at is now auto-populated by a date based on the date on another sheet in the workbook. So now the field on the Dashboard never turns to C for complete. I thought I found the answer with =IF(8-COUNTIF(Star,"<>"&""
)) but I discovered that when the criteria is tested it looks at the cells in the range that are pulling it's data from other worksheets, 3 cells in total, as being populated even though there is nothing there. Also discovered this would not have worked cause the formulas in those cells do a math function until a criteria is met and then the cell displays an "A". Any ideas on how to fix this so that it will count the field if a date appears in the field?
I have attached the template I am currently working on.