I have 2 lists on one SharePoint site. One works as a query log (I used a custom list instead of issue tracking) and a second one is a master data list with a RAG status.
What I want to achieve is to have a count of open logs in a query log list (with a status different than "Closed" from column "Query Status") appearing in the master data list.
Common column between the two list is "Item Reg". In query log I can have a number of logs created for Item Reg: FR1982 and in master data list I can only have one item with Item Reg: FR1982.
I'd need this count of open logs appear in one of the columns in master data list and update automatically by a workflow each time a new log is created in query log list or status of existing log is changed in query log list.
Thank you!