Counting values in look up fields

Baserow Help
, ,
1

Please, is there a way I can count the number of occurrence of a particular value in a lookup field that contains multiple values.

I want to create a formula field that can display the number of times a specific value occured in a lookup field so that I will be able to sum it up.

2

Yes,

You can achieve this by combining the count() and filter() function in a formula:

count(filter(lookup(field you like to count), lookup('field for the condition') = 'condition value'))
1 Like
3

Great! It worked! Thank you for your time, Frederick.