I have a google sheet where I collect responses and another tab where I see a report for each record.
I want to add manually a number in the cell Writing Points (as in the image below) and click Update to update the cell of that specific record in the responses tab.
I managed to get the row number depending on the student the formula is:
And the column is always BG of the repsonses tab.
How can I achieve this through google script? I have an idea but I don’t know how to do it.
row = MATCH($D$3,Responses!D:D, 0)
I don’t know how to conver the match formula into google script syntax and how to copy and paste the value from that cell to the responses tab.
Google Sheet link:
Any help would be much appreciated.