Hi I am having trouble with appscript code .he, I am looking to generate email reminders for tasks that are still in “assigned” status end of the month!
Function sendEmail(){
Bar sheet = spreadsheet.getactivesheet();
Var startrow = 3;
Var numrows = 43;
Var daterange = sheet.getrange(setrow, 3, numrows, 43)
Var data= data range.getvalues();
For (i in data) {
Var row= dat[i] {
Var emailaddress = row [0];
Var message = “pending task” + row[1];
Var subject = “pending task”
Mailapp.sendemail(emailaddress, subject, message);
}
}
}
- List item
Pulling email address from column 1, task name from column 2, status field “assigned
List item Pulling email address from column 1, task name from column 2, status field “assigned. Can I ask you about the detail of the current issue of your script and your goal? - Tanaike