Counting two columns
Hi! I want to be able to count two columns next to each other (my subproject and task columns, which I use symbols to denote respectfully). I can figure out how to do the one column  =COUNT(CHILDREN([SUBPROJECT:]@row)) but can't figure out how to add on to my equation to also count my task column, which is called TASK:
Answers

To find the count of subproject children and task children you can add the two results together using +
=COUNT(CHILDREN([SUBPROJECT:]@row)) + COUNT(CHILDREN([TASK:]@row))

I did that and it gave me a duplicate number. For example, one project had 2 subprojects and no tasks. But it gave me a total number of 4...

Can you share a screenshot of your sheet? You can obscure anything that should not be shared publicly.
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!