RAID Log and creating notification email to a group based on a calculated column


I’ve create a RAID log within Monday.Com that includes a calculated field that gives a risk score. I would like to automatically send a weekly email to people that contains all rows (risks) where the score is above a certain value. I would also like to filter the rows to only include certain values based on a label. The pseudo code would be something like…

select row where projectname in (“Project 1”, “Project 3”) and RiskScore >=25

Is this possible? I am including all project risks in a single table for easier management.

I had hoped to be able to create a automation to handle this but I can’t see the option to filter on anything other than the status field.