Help with a composite column template formula

[Snomad]

Hi all,

I'm looking to create a composite column formula that displays common genres listed in the tags column. Using a composite column means it will always be up-to-date when new books are added, so I feel this is a better option than bulk copying tag information. Unfortunately, I have not been able to determine from help pages how to write this formula, I believe it begins {tags:... but that is as far as I can get. The values I am looking to find and display are:

Action and Adventure
Comedy
Crime and Mystery
Fantasy
Horror
Science Fiction
Romance

The column is already set up as 'behaves like tags' which I believe is necessary to achieve this but please let me know if I am mistaken.

Thanks!

[Ghostcat]

I have a similar custom column, which uses the following:

program:
    list_intersection(field('tags'), 
	'Action and Adventure,Comedy,Crime and Mystery,Fantasy,Horror,Science Fiction,Romance', 
	",")

And yes, "Column built from other columns, behaves like tags" is the way to go.

[Snomad]

Thank you, that works perfectly!