Automation if a certain criteria is not met

Options

I am needing an auto email to be sent out once weekly if certain things are not filled into a column on one of my sheets.

There are a lot of different options for this column I need an email to go to certain people if any of the options on this dropdown are not populated that week.

Answers