For some reason, whenever I run this function, it first takes a very long time to execute but secondly always replaces in cell E9, rather than going to the next available cell (in this case E10).
This is my code:
var RecruitRosterRange = RecruitRoster.getRange(1,1,RecruitRosterLastRow,7);
var RecruitRosterRangeValues = RecruitRosterRange.getValues();
var RecruitRosterRow = 8;
while (RecruitRosterRow <= RecruitRosterLastRow)
{
if (RecruitRosterRangeValues[RecruitRosterRow-1][1] == "") // Is Website ID cell blank?
{
RecruitRoster.getRange(RecruitRosterRow, 5).setValue(AutomationSheet.getRange(asFTAddWebID).getValue()); // Add Website ID to website ID column on Recruit Roster
RecruitRosterRow = RecruitRosterLastRow+1;
}
//Repeats if not
else
{
RecruitRosterRow++;
}
}```
And this is my sheet:
[sheet][1]
[1]: https://i.stack.imgur.com/k6kXm.png
If you need any additional screenshots or explanation, please let me know. Thank you!