COUNTIFS WITH CONTAINS

Morgan.Win
Morgan.Win ✭✭
in Formulas and Functions

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!

Tags:
· Share on FacebookShare on Twitter

Best Answers

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

    Jacob Stey

    · Share on FacebookShare on Twitter
  • Carson Penticuff
    Carson Penticuff ✭✭✭✭✭✭
    Answer ✓

    Try this:

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

    · Share on FacebookShare on Twitter

Answers

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!