Count number of times a word comes up in a linked records list

[mila93]

How can I count the number of records in the list "Attended Session & Challenge" that are specifically only from 2023? 

The attendance is based on a form they fill in that is in a different tab in the same workspace. 

help would be very appreciated! Thanks. 

[TheTimeSavingCo]

Hmm, perhaps try creating a formula field with "YEAR" like so:


Which will allow you to create a "Count" field in your main table and set a conditional like this:

Resulting in this:

Link to base

[mila93]

it worked thanks!