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

Topic Labels: Formulas
260 2
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Screenshot 2024-02-26 at 11.40.05.png

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. 

2 Replies 2

Hmm, perhaps try creating a formula field with "YEAR" like so:
Screenshot 2024-02-26 at 7.43.19 PM.png

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

Screenshot 2024-02-26 at 7.43.11 PM.png

Resulting in this:

Screenshot 2024-02-26 at 7.43.08 PM.png

Link to base

it worked thanks!