Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

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

Topic Labels: Formulas
772 2
cancel
Showing results for 
Search instead for 
Did you mean: 
mila93
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!