Looking for textmode for a column that counts parent tasks | Community
Skip to main content
J
Justin_Charles
New Participant
March 22, 2024
Solved

Looking for textmode for a column that counts parent tasks

  • March 22, 2024
  • 2 replies
  • 1044 views

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!

Best answer by Doug_Den_Hoed__AtAppStore

 

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= listmethod=nested(tasks).lists textmode=true type=iterate valueexpression=CONCAT(IF({numberOfChildren}>0,IF(CONTAINS("Round",{name}),"*",""),"")) valueformat=HTML

 

Regards,

Doug

2 replies

J
Justin_CharlesAuthor
New Participant
March 26, 2024

bump!  anyone have expertise in this area?

Doug_Den_Hoed__AtAppStore
Doug_Den_Hoed__AtAppStoreAccepted solution
New Participant
March 26, 2024

 

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= listmethod=nested(tasks).lists textmode=true type=iterate valueexpression=CONCAT(IF({numberOfChildren}>0,IF(CONTAINS("Round",{name}),"*",""),"")) valueformat=HTML

 

Regards,

Doug

    J
    Justin_CharlesAuthor
    New Participant
    March 28, 2024

    Thanks Doug.  This successfully returns a count of stars for each round per project.  Is it possible to return a number instead of a star count?  So the number 5 instead of *****?  I'm able to do this in excel, but would be ideal to have it done within Workfront.

     

    Thanks!

    Scott_Goodwin
    Scott_Goodwin
    New Participant
    March 23, 2024

    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. 

    J
    Justin_CharlesAuthor
    New Participant
    March 26, 2024

    thanks for your reply scott.  however, the parent tasks with the word "round" are indeed within other parent tasks.

    Terms & ConditionsAccessibility statement

    Loading footer...