COUNTIFS Formula Help



I am trying to create a formula for my Dashboard Matrix. I need to count the Projects for Fofi Kantas listed as Project and Enhancement.

=COUNTIFS({Project Owner}, FIND("Fofi Kantas", @cell) > 0, {Type}, "Project")

I can count them for each but cannot figure out the formula for project or enhancement.

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!