I have a Google Sheet which should perform some calculations in other sheets in my Google Drive.
In column A of my sheet there is a persons name, for example John Doe. Based on this value the script has to find an other sheet in a specific Drive folder called 'research'. In this folder there is 'John [url removed, login to view]'. In this .CSV the script should perform a countif with 2 variables (in 2 different columns). The result of the countif must be placed in the main sheet, next to the name of the person, in column B.
For every row this calculation should be performed.
Who is able to write this? I can give you some material (sheets) to work with and test on.