and welcome to the Coda Community!
Your formula is almost OK… You are trying to compare a text with a row reference.
You have two ways to make it work:
- Make the
tags column in
Table 1 a lookup to the
Table 2 table rather than a select list (recommended)
- You add the column
tags lists of
Table 2 in the formula:
[Table 1].[tags].ListCombine().Filter(CurrentValue.Contains(thisRow.[tags lists])).Count()
I hope this helps.
I’d suggest to change the post to the “Ask the Community” category.
Usually “How To” and “Doc Show and Tell” are to explain some ideas or solutions.