Is it possible to count all subtopics that have specific tags using a property formula?

Adam M. shared this question 19 days ago
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

Replies (3)

photo
1

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.

photo
1

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.

c6988994ddd664f9549c0c96bd70e4de

2dfc1cb12d230701ccdcb1a9852c546c

e6276afe70f788b7d4d043e3fe42e64e

photo
1

And in addition...

In de index/markerlist you can find the country of any marker or tag you used in your map

photo
1

Count not country !!!

photo
photo
1

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.

Leave a Comment
 
Attach a file