Formula Counting Courses Required /Taken
Have a smartsheet that shows by student (each row is a student) what course they are required to take. The student updates the date they completed the course via update requests. Based on this smartsheet I am trying to find a formula that will show me when they have completed all courses that they are required. The required course columns are a dropdown with a yes if the need to take the course and blank if they do not. The completion columns are date columns that they update if they have completed the course, and blank if they had not. My thought was to create a formula that would produce a one if the student had a yes in any of the course fields, and a date in any of the completion cells. This would tell us that they had completed all the courses they are required to take.
I have tried unsuccesfully to create anything that will work. Appreciate any suggestions on how we accomplish this.
Help Article Resources
Check out the Formula Handbook template!