Countifs + find formula


I have a formula I'm having an issue with.   I'm trying to count how many projects are assigned to a individual in the "Assigned To" column that contains a partial description "green Ties" in the "task Name" column.

here's my formula I came up with and need help to get it right.

=COUNTIFS([Assigned To]1:[Assigned To]160, =Dan R,[Task Name]1:[Task Name]160, FIND("green Ties" @cell) > 1)




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!