How to count data in children rows based on criteria in parent rows
Hello all. I am thinking this would best be done in a Sheet Summary but my brain seems to still be in winter break mode. Hoping someone can point me in the right direction.
My Smartsheet is a list of courses (parent rows including course title and date) with participants (children rows including participant names and a multi-selection field with various consent form types). In this case, the Primary Field is actually the course date (many courses have the same name; the date is the only field unique for each course) – so it is a text field where the first four characters are the year (i.e 2019/01/17).
I need a count of a specific consent form received for participants in a given year. For example, how many participants signed a "human factors" consent form where the Course (ancestor) has “2019” in the Course Date (text) field.