Untitled
unknown
plain_text
6 months ago
815 B
3
Indexable
function assignPoints() { const sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Attendance Tracker'); const range = sheet.getRange('C2:D' + sheet.getLastRow()); const data = range.getValues(); data.forEach((row, index) => { const eventType = row[0]; let points = 0; switch(eventType) { case 'Fundraiser': points = 2; break; case 'GBM': points = 1; break; case 'Social': points = 1; break; case 'Clinic Donation': points = 1; break; case 'Volunteer Event': points = 1; break; case 'Attend Clinic': points = -3; break; } data[index][1] = points; // Assign points to the second column in the range }); range.setValues(data); // Update the sheet with new points }
Editor is loading...
Leave a Comment