So, I need to track my employee's attendance. On the Summary tab I would like for their name to populate if they are scheduled to work that day (see Schedule 1 or Schedule 2 tabs) and they do not scan into work (see tabs Monday - Saturday) therefor making them absent. I would love if it was possible to use the Schedule 1 tab to do this as I am currently using this format as our scheduling tool.
I have tried using conditional formatting and several formulas (OR, MATCH, COUNTIF) but with no luck. Can anyone please point me in the right direction?