Tracking that updates are received from employees

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?

Find more posts tagged with

Formulas

Accepted answers

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)

All comments

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)

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.