Count and Concatenate Text

Evonn Scotlen · 05/04/22

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 · 05/04/22

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

Evonn Scotlen · 05/04/22

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

Evonn Scotlen · 05/04/22

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

Count and Concatenate Text

Best Answer

Answers

Categories