How do I use Kaban Tags in Formulas

This isn't working because Kanban tags - and tags generally - are not numeric task attributes and therefore aren't recognised in formulas.

What you need to do is write three SmartRules that will use the tags as triggers to create task property values, one for each Kanban status. First, create the three task properties - ToDo, Doing and Done - and copy them to all the tasks you want to include. Then create the three SmartRules, which should look like this:

- repeat for Doing and Done (the value is always 1).

Then add the formulas to the central topic, which should all follow this format: [ToDo Total]=SUM(Descendants.[ToDo])

You should end up with something like this:

I have followed your instructions but still cannot seem to make it work.

The names of the topic properties you are using in the formulas in the central topic don’t match those of the properties that you have added to the tasks. I think that somehow you have added the topic property names you should end up with on the central topic, eg, “total doing”, rather than just simply “doing”.

Sorry, I think I forgot a step. I didn't assign the properties to the topics. I am trying again. I appreciate your help.

It might be easier to turn all Tag attributes to Number. I have entered most of the Properties but the formulas are not working correctly. I show only one value in a child and not in the central topic.

I just realized what is happening here. I am attempting to automate the counting of tags and here we are creating a property where we have to manually enter the number in the appropriate property. Is there a way to count the tags applied to the topics without manually recreating the values?

In essence that’s what you are doing. Just follow the steps as I described - I’ve outlined them in more detail below:

1. Select a task and add three numeric task properties, ToDo, Doing and Done.
2. Copy and these properties to all the tasks.
3. Create and save a ToDo SmartRule with the Kanban tag group contains To Do as the trigger and the effect of putting the number 1 in the ToDo topic property.
4. Create and save an additional rule for each of the other Kanban tags following the same syntax.
5. On the central topic add the Total ToDo formula I described earlier: ToDo Total]=SUM(Descendants.[ToDo])
6. Repeat to create the Total Doing and Total Done formulas.

If you are still having difficulties I could attach my example file to a future comment, but I’m away from my computer at the moment.

I'm missing two "Done" tags, but I think we are getting close.