Automation wont run on a blank sheet

Hi, I have a sheet that collects data from several forms. I have an automation that kicks off every Thursday at 5:00 AM to move all the data in the sheet to an archive sheet, I have another automation that is supposed to kick off at 8:00 on Thursday to check if the column is blank, then alert someone via an email to enter new data. The 8:00 automation is not working with the blank sheet, even if I click "Run Now" it still won't work. If I manually enter data and click "Run Now" the automation works. My question is: Why won't it work on an empty sheet?

Any help is appreciated.

Best Answer

Answers