Count and Concatenate Text
Options
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 _"
Best Answer
-
="Total Completed: " + COUNTIF(CHILDREN(), 1) + " of " + COUNT(CHILDREN())
Answers
-
="Total Completed: " + COUNTIF(CHILDREN(), 1) + " of " + COUNT(CHILDREN())
-
Ended up figuring the answer out here it is for anyone that needs it! GO! WEB3