I have successfully attempted to move a row in the Queue Sheet to the last row in the Tasks Sheet upon "Scheduled" being selected.
The problem comes in when I have a hidden formula in Column D in the Tasks sheet. The script I have will skip these rows and effectively make the last column a row that does not have this hidden field instead of the first "empty" row.
Can someone help me edit my script so that empty rows are considered the last row instead of the first row that does not have this hidden formula?
You can view the sheet here: https://docs.google.com/spreadsheets/d/1sd48Q7CkKRtJhdB7TdcNDNFQ7wQQ9AbeLP41HLjVYo0/edit?usp=sharing
You can view the hidden formulas in D23 to D31 in the "Tasks" sheet.