Tracking that updates are received from employees

Kimberley O

I have created a sheet for employees to provide numeric updates at 10AM, 2PM, and EOD.

On a separate sheet, I am trying to create an automatic checklist to ensure all updates are received and that will send reminders if their update is missing. My checklist looks like this:

I have used this formula on a checklist for just checking that the employee's name is present on the update and that works great.

=IF(COUNTIFS({Employee}, Employee@row) 0,1)

However, I cannot figure out how to have it check both the name and the column. Any suggestions?

Paul Newcome

You would simply need another range/criteria set to evaluate if there is an entry (for example) for that person where the 10AM column is not blank.

=IF(COUNTIFS({Employee}, Employee@row, {10AM Column}, @cell <> "") = 0,1)

Paul Newcome

You would simply need another range/criteria set to evaluate if there is an entry (for example) for that person where the 10AM column is not blank.

=IF(COUNTIFS({Employee}, Employee@row, {10AM Column}, @cell <> "") = 0,1)