Formulas and Functions
Formulas and Functions
Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.
COUNTIF CHILDREN in the Sheet Summary
Hi!
I am trying to count the number of projects for each country in the Sheet Summary menu to use that values on a dashboard. I know how to use COUNTIF and CHILDREN in cells, but I can't figure out how to use this combination in the Sheet Summary menu. Here is my screenshot:
Help, please!
Best Answer
Answers
-
-
Thank you a lot! It's so simple 😀
The root of the problem was that I was trying to reference the cell Country1, but had to reference Project1.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!