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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.