Is it possible to count all subtopics that have specific tags using a property formula?
Discussion Open
Hi folks, I'd like to be able to count the subtopics that have a specific tag and place that result into a property.
Example, [Property_Name]=COUNT(Children.[Tag_Name])
I get a result of "0". Am I doing this incorrectly? Can this be done?
Thanks,
Adam
Hi Adam,
The property that you are counting has to be numeric and there has a number in it. If you just want to obtain the count it doesn't matter what the number is.
Hi Adam,
The property that you are counting has to be numeric and there has a number in it. If you just want to obtain the count it doesn't matter what the number is.
Hi Adam,
Alex has already said the important thing. You can do various things with a workaround.
You can do a lot with Tag + Smartrules + Properties + Formulas + Filters.
Hi Adam,
Alex has already said the important thing. You can do various things with a workaround.
You can do a lot with Tag + Smartrules + Properties + Formulas + Filters.
Hi Adam,
Sorry - I misread your question slightly. As I said you can count topic properties, and you can also count (or sum, average, etc) other task attributes like progress, priority, etc), but not unfortunately tags. However, to amplify René's point you can use a SmartRule to add a topic property value to topics based on whether they have a tag or not, then sum or count these properties.
Hi Adam,
Sorry - I misread your question slightly. As I said you can count topic properties, and you can also count (or sum, average, etc) other task attributes like progress, priority, etc), but not unfortunately tags. However, to amplify René's point you can use a SmartRule to add a topic property value to topics based on whether they have a tag or not, then sum or count these properties.
---