COUNTIFS WITH CONTAINS

I am trying specify counting only rows that contain "UO" within the Department column, are less than one year and the withdraw/rescind column is blank. I am able to achieve the counting of withdraw/rescind less than one year with the below formula, but when I add contain I continue to get the response #INCORRECT ARGUMENT SET. What am I missing in the CONTAINS formula that is not generating the correct data?

=COUNTIFS([Entry Date]:[Entry Date], >TODAY(-365), [Withdrew/Rescind Reason]:[Withdrew/Rescind Reason], "", CONTAINS("UO", Department:Department))

Thanks!

Find more posts tagged with

Countif

Accepted answers

SteyJ

=COUNTIFS([Entry Date]:[Entry Date], >TODAY(-365), 
[Withdrew/Rescind Reason]:[Withdrew/Rescind Reason], "", 
Department:Department, CONTAINS("UO", @cell))

Carson Penticuff

Try this:

=COUNTIFS([Entry Date]:[Entry Date], >TODAY(-365), [Withdrew/Rescind Reason]:[Withdrew/Rescind Reason], "", Department:Department, CONTAINS("UO", @cell))

All comments

SteyJ

=COUNTIFS([Entry Date]:[Entry Date], >TODAY(-365), 
[Withdrew/Rescind Reason]:[Withdrew/Rescind Reason], "", 
Department:Department, CONTAINS("UO", @cell))

Carson Penticuff

Try this:

=COUNTIFS([Entry Date]:[Entry Date], >TODAY(-365), [Withdrew/Rescind Reason]:[Withdrew/Rescind Reason], "", Department:Department, CONTAINS("UO", @cell))

Morgan.Win

Perfect! Thank you both so much!

SteyJ

https://community.smartsheet.com/discussion/comment/405316#Comment_405316

anytime 👍️

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.