=COUNTIFS(Team:Team, "EPS", Disposition:Disposition, "Extend as is", QTR:QTR, "FY22 Q2"), AND([Days Extended prior to Expiration]:[Days Extended prior to Expiration], >30)
Hello @Yanneth
The syntax needs some tweaking in the above formula.
=COUNTIFS(Team:Team, "EPS", Disposition:Disposition, "Extend as is", QTR:QTR, "FY22 Q2", [Days Extended prior to Expiration]:[Days Extended prior to Expiration], >30)
Kelly
I tried that, and does not work. I get a message of invalid operation
Hey Yanneth
Is it possible to see a screenshot so that I can verify the data you're entering is what the formula is expecting?
For troubleshooting purposes, begin removing the range-criteria pairs, one by one. I would start at the end and remove the [Days Extended Prior to Exp] and the .>30. This will help pinpoint if there is a specific term that is causing the problem.
This is my table, I do have a good result with out the last criteria, it is when I add the last criteria that the formula does not work
Hey @Yanneth
In the screenshot above the [Days Extended prior to Expiration] field is blank. I wanted to see if you have only numbers in that field.
Let's see if this works
=COUNTIFS([Days Extended prior to Expiration]:[Days Extended prior to Expiration], ISNUMBER(@cell), Team:Team, "EPS", Disposition:Disposition, "Extend as is", QTR:QTR, "FY22 Q2", [Days Extended prior to Expiration]:[Days Extended prior to Expiration], >30)
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.
