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)))

Best Answer

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭
    Answer ✓

    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:

    PMP Certified

    [email protected]

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!