I need to count all records where a specific entry is made

Topic Labels: Formulas
890 1
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi there. I currently have two tables. My {School} table includes a column called “Age Group” which is a Multiple select field. This field provides the selection options of Pre-School, Year 1, Year 2, Year 3 etc.

I have another table called Statistics with a rollup linking back to the “Age Group” field in my {Schools} table.

I want to create a rollup or other formula that looks at all the schools from Bedfordshire, then counts to see how many of them have “Year 1” etc selected in the Age Group field. This to then be displayed as a total.

Any help would be greatly appreciated.

1 Reply 1
5 - Automation Enthusiast
5 - Automation Enthusiast

OK so I think I see where the problem is. The Age Group is a multiple select option not single select. If it were single select the formula **

IF({Age Group}=“Year 1”,1,0)

** would work perfect. How can I set this formula to work if “Year 1” has been included regardless of what other years have also been selected?