How do I get Countif, Find, and Contains in one formula to work?

In my pipelines metrics sheet I am trying to get a formula to find the external account holders name along with closed won, for a count of how many that account holder has closed a win. This is one equation i am trying an dI am not getting it to work to count both.....any help would be greatly appreciated

=COUNTIF({Sheet - Sales Pipeline Range 1}, FIND("External Account Holder", @cell) > 0, CONTAINS(Closed Won, @row))

Best Answers



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!