Issue with CountIFs function

Options

Hi all i'm currently attempting to use a COUNTIF function to count with 3 conditions. However my output comes up with 0 when there are more than 0 items that meet the criteria. Can anyone assist to see if my formula is incorrect?


=COUNTIFS({Type}, HAS({Type}, "Storyline"), {Current Maintenance Assignee}, "Earl Prentice", {Production Status}, "Live")

Answers

  • Dale Murphy
    Dale Murphy ✭✭✭✭✭✭
    Options

    @Earl P

    I don't think you need the HAS clause. Try COUNTIFS({Type}, "Storyline", {Current Maintenance Assignee}, "Earl Prentice", {Production Status}, "Live")

    Or, replace HAS({Type} with HAS(@cell) - that also seems to work but is more complicated.

    dm

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!