COUNTIFS WITH CONTAINS

Morgan.Win

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!

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

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 👍️