Skip to main content

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


Forum|alt.badge.img+2

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

TheTimeSavingCo
Forum|alt.badge.img+28

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


Forum|alt.badge.img+2
  • Author
  • New Participant
  • 1 reply
  • February 26, 2024
TheTimeSavingCo wrote:

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


it worked thanks! 


Reply