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

Platform discussions
,
1

Hi,

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.

Thanks,

David

2

Hey @GreenCorrie can i ask how you approached creating the RAID log? We are fairly new to Monday and looking to bring this into our Monday projects but I can’t see a very clean way to do this on a project board. We were shown a risk register template but this isn’t quite what we need either.

3

@GreenCorrie The automation recipe from the available templates - Notifications > “When a number is greater than a value, then notify someone” seems to have a close match with what you are looking for. Did you already try that?