Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

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

Topic Labels: Formulas
667 1
Showing results for 
Search instead for 
Did you mean: 

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

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?