Formula to find many times an employee failed on a task

I am trying to write a formula that will keep track on how many times an employee failed to document properly for the last 28 days. Below is the formula I tried with no success ( I have replaced the employee's last name with asterisk's for privacy). I have also attached a screenshot of the sheet I am tracking on.

Any help would be greatly appreciated.

=COUNTIFS([Responsible employee],<>"Brandon ****", [Date of failure], AND(@cell <= TODAY(), @cell >= TODAY(-28)))

Find more posts tagged with

Accepted answers

Bassam Khalil

Hi @Robert Harrison

Hope you are fine, please try the following formula:

=COUNTIFS([Responsible employee]:[Responsible employee], HAS(@cell, "Bassam Khalil"), [ate of failure]:[ate of failure], AND(@cell <= TODAY(), @cell >= TODAY(-28)))

the following screenshot shows the result:

All comments

Bassam Khalil

Hi @Robert Harrison

Hope you are fine, please try the following formula:

=COUNTIFS([Responsible employee]:[Responsible employee], HAS(@cell, "Bassam Khalil"), [ate of failure]:[ate of failure], AND(@cell <= TODAY(), @cell >= TODAY(-28)))

the following screenshot shows the result:

Robert Harrison

That worked perfectly. Thank you so much for your help.

Bassam Khalil

@Robert Harrison

Excellent, please accept my answer on this post.

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.