I did find few scripts about how to make Google Forms result sheets to auto-create new sheets by a specific data in a cell. I did not manage to get the scripts to work - and I was wondering if conditional formatting could be added to the script too.
So, lets say my sheet document is named 'campaign'. The sheet with the used data is named 'data'. That sheet has header row which does not need to be copied to the new sheets. Column E on that sheet is named 'workplace'. Whenever there is a new workplace added to the list I would want the script to auto-create a new sheet and name it with the workplace value/data/info. At the same time I would like the script to copy the specific row into the new sheet.
Could someone tell me how to write a working script for this?
As a bonus question: In the 'data' sheet is also a column named 'score'. When the script copies the rows into the auto-created sheets, can the script also apply conditional formatting based on the value in the column 'score' (we can say the column is G)? For example if the value in the copied row is 1, make the background of the cell green, 2 = yellow and 3 = red.
I would also like the script to run only with the specific document 'campaign' not with any other sheets. Is that doable too?