Issue with CountIFs function


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


  • Dale Murphy
    Dale Murphy ✭✭✭✭✭✭

    @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.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!