Tips for Showing Count of Answers Completed on a Smartsheet?
If I have a section with three rows underneath my heading, I'm able to easily use a formula to show the count of tasks completed/responded to out of my total number:
="Introduction: " + COUNT(Response4:Response6) + " of " + COUNT(CHILDREN())
However, if I have a section with multiple sub-sections, I'm struggling to use a formula to show this information. For example, my "Logistics" section has 4 sub-sections, and the formula does not work for this. It will allow me to add more than my total number of children. See screenshot 2.
Does anyone have ideas on how to use a formula in this situation?
Help Article Resources
Check out the Formula Handbook template!