Count and Concatenate Text

Evonn Scotlen

Count the total number of checked boxes in the children rows of [Completed] and compare that number with the total number of checkboxes using concatenated text.

Your answer should look like this: "Total Completed: _ of _"

Evonn Scotlen

="Total Completed: " + COUNTIF(CHILDREN(), 1) + " of " + COUNT(CHILDREN())

Evonn Scotlen

="Total Completed: " + COUNTIF(CHILDREN(), 1) + " of " + COUNT(CHILDREN())

Evonn Scotlen

https://community.smartsheet.com/discussion/comment/328299#Comment_328299

Ended up figuring the answer out here it is for anyone that needs it! GO! WEB3