Daily notification automation linked to a certain column value

Hi all, is it possible to set up an automation (with also a workaround) that does this:
check every day if a date column is empty (or a formula column is true, or a formula column cointain a certain value) and notify the owner of this?

We would like to ensure that users are reminded to fill in some empty columns which are not punctually filled in but which are extremely important. Despite continuous internal prompts, certain values are never populated and I would like to automate the notification.