COUNTIFS+CONTAINS+AND

Options

I am trying to write a sheet summary formula to count the number of rows where: Sprint Name contains "Maintenance", Date Resolved is not blank, and Bug or Request equals "Bug"

[Sprint Name]:[Sprint Name], CONTAINS("Maintenance")

and

[Date Resolved]:[Date Resolved], <>""

and

[Bug or Request]:[Bug or Request], "Bug"

I tried the following: =COUNTIFS([Sprint Name]:[Sprint Name], CONTAINS("Maintenance"), [Date Resolved]:[Date Resolved], <>"", [Bug or Request]:[Bug or Request], "Request") but I receive an #INCORRECT ARGUMENT SET error.

Tags:

Best Answer

  • Carson Penticuff
    Carson Penticuff ✭✭✭✭✭✭
    Answer ✓
    Options

    CONTAINS() must include the range to compare. You can use @cell in this instance.

    =COUNTIFS([Sprint Name]:[Sprint Name], CONTAINS("Maintenance", @cell), [Date Resolved]:[Date Resolved], <>"", [Bug or Request]:[Bug or Request], "Request")

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!