Skip to main content

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

  • February 26, 2024
  • 2 replies
  • 28 views

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+31

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
  • February 26, 2024

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!