We own a company where we have a Done for you team member placement service and we want to track if they have filled in their End of the Day report every day.
Right now I have:
- 1 sheet where we collect our team members names
- 1 sheet where we collect the EOD reports
I would love to automate the manual work of finding out who DIDN’T filled in the EOD report by the end of the day (11:45PM) so I can follow up with them the day afterwards.
I tried the automation, but I get a bit stuck here. Can someone help? :slightly_smiling_face: