I’ve created a form that I’ve asked employees to fill out daily to help us track COVID-19 systems in our work force. I have a second table in my base that has the entire employee list with emails. I would like to create a formula/view where I can see who hasn’t filled out the form on a particular day so that I can send an email reminder to ping them.
It’s not as simple as a date match, because I don’t want to see previous dates, only a particular date to see who is missing if that makes sense.
New to doing this and any help is greatly appreciated!