Looking for textmode for a column that counts parent tasks

Question

Hello! I'm looking for text mode for a column on a project report that will count how many times there is a parent task that contains the word "Round."

In our templates we have rounds of revisions that have numbered parent tasks (Round 1, Round 2, Round 3, etc). So for example if a project's task list has 3 parent tasks that have the word "Round" in it (such as Round 1, Round 2, Round 3), I want a column on a report that returns the number 3, to show a count of those.

Any help is greatly appreciated - thanks!

Doug_Den_Hoed_AtAppStore · Accepted Answer

Hi @justin_charles,

Your question reminded me of this similar answer I invented a while back, which I invite you to review for background, and then consider applying via something like this:

displayname=Number Of Parent Tasks Containing Round
listdelimiter=&#xfeff;
listmethod=nested(tasks).lists
textmode=true
type=iterate
valueexpression=CONCAT(IF({numberOfChildren}>0,IF(CONTAINS("Round",{name}),"*",""),""))
valueformat=HTML

Regards,

Doug

Scott_Goodwin · Answer

Hello @justin_charles

Forgive me I'm on my phone so I can't do a full example however if they are parent tasks and not within a parent task you could use parentID is blank and then check for "Round"

This assume that the Round parents tasks are not within a Parent themselves.

Hopefully this helps.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded