Pass fail percentage pulled from other sheet

Ok, hi! I was trying to use an old formula and edit it to my needs but it is way too convoluted. Basically i am pulling p, f, and blank from one column in a sheet and want it to give me a percentage of passing on another. This i s even further brokwn down by person (email column) and month (can be date column or month columnn "july"). I got close witht he below reading the users and giving htem a score but it clearly isnt accurate as its just giving me 0% and there are very few fails so it would not be 0%. Am i missing something? I know other sheets nit he past ive made a column to give p and f 1's and 2's to read a score. is that something im missing?

=COUNTIFS({TTR Outcome}, "p", {Employee Email TTR}, Variable@row , {Date of Review TTR}, >=DATE(2025, 7, 1), {Date of Review TTR}, <=DATE(2025, 7, 31)) / COUNTIFS({Employee Email TTR}, Variable@row , {TTR Date}, >=DATE(2025, 7, 1), {TTR Date}, <=DATE(2025, 7, 31))

Find more posts tagged with

Accepted answers

All comments

jjg279

Hey Katherine, it looks like it should be working, one thing you might check would be your "Employee Email" and "Variable" columns - are they the same type of column (Contacts vs Text/Number)? That might be causing it to return no findings.

Katherine Camacho

Thanks @jjg279 for the insight, they are both contact columns so unfortunately that isn't it. Im wondering if maybe its a math issue im not seeing since its the pass column / all columns

jjg279

Oh! You are totally correct! You need to wrap your dates in an "AND" statement!! Here is an article about it

But I think your formula would look something like this:

=COUNTIFS({TTR Outcome}, "p", {Employee Email TTR}, Variable@row , AND({Date of Review TTR}, >=DATE(2025, 7, 1), {Date of Review TTR}, <=DATE(2025, 7, 31))) / COUNTIFS({Employee Email TTR}, Variable@row , AND({TTR Date}, >=DATE(2025, 7, 1), {TTR Date}, <=DATE(2025, 7, 31)))

Katherine Camacho

Unfortunately that did not fix things either. I did notice if i just do the front half of the formula I get a 0% so it works but not correctly. i think that would at least pull 100%

=COUNTIFS({TTR Outcome}, "p", {Employee Email TTR}, Variable@row , {Date of Review TTR}, >=DATE(2025, 7, 1), {Date of Review TTR}, <=DATE(2025, 7, 31))

jjg279

@Katherine Camacho Howdy! I am sorry, I am still getting used to the new set up for discussions, did you resolve this? I am wondering about your 0%, have you tried just doing each aspect by itself for de-bugging? Just =COUNTIFS({TTR Outcome}, "p") then =COUNTIFS({Employee Email TTR}, Variable@row) to see where it might not to returning what you expect?

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.