Expand my Community achievements bar.

SOLVED

Text Mode Reporting with multiple task statuses

Avatar

Level 2

I need help building a text mode column on a task report, unless there is a better suggestion of how to accomplish what I am looking for outside of using text mode. I attached a picture of my task template in workfront.

 

I would like to add a column that can compute the following: If 'VRT - Order Placed' parent task percent completed is equal to 100% AND 'VRT - In Progress' parent task is equal to 0%, show 'Order Placed' in the report column. If 'VRT - In Progress' parent task percent completed is between 1% and 99%, show ' Order in Progress' in the report column. and if 'VRT - In Progress' parent task percent completed is 100% then show 'Order Completed' In the report column. Is there a way to accomplish this? I know its difficult with reporting on 2 tasks and 2 different % statuses. Any help would be appreciated! 

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Level 10

hello Kaylee,

 

this should absolutely be possible to achieve using text mode.

 

You need to exchange any value and valuefield entries in your textmode by a single

 

valueexpression=

 

followed by a combination of a syntax like this:

 

IF(CONTAINS("order vrt files",LOWER({name}))&&{percentComplete}=0,"VRT Order Not Started",IF(CONTAINS("order vrt files",LOWER({name}))&&{percentComplete}<=20,"VRT Order Placed",IF(CONTAINS("order vrt files",LOWER({name}))&&{percentComplete}>20&&{percentComplete}<=99.8,"VRT Order in Progress","VRT Order Completed")))

 

 

To get the percentComplete value of the parent task you need to use 

 

{parent}.{percentComplete}

 

in your valueexpression.

 

Regards

Lars

View solution in original post

2 Replies

Avatar

Level 2

another option could be for a project report with a text mode column that shows the following: 

If task name is ‘Order VRT Files’ and task percent completed = 0% then display ‘VRT Order Not Started’ in column

If task name is ‘Order VRT Files’ and task percent completed 20% then display ‘VRT Order Placed’ in column

If task name is ‘Order VRT Files’ and task percent completed 20.1%-99.8% then display ‘ VRT Order In Progress’ in column

If task name is ‘Order VRT Files’ and task percent completed 100% then display ‘ VRT Order Completed’ in column

Avatar

Correct answer by
Level 10

hello Kaylee,

 

this should absolutely be possible to achieve using text mode.

 

You need to exchange any value and valuefield entries in your textmode by a single

 

valueexpression=

 

followed by a combination of a syntax like this:

 

IF(CONTAINS("order vrt files",LOWER({name}))&&{percentComplete}=0,"VRT Order Not Started",IF(CONTAINS("order vrt files",LOWER({name}))&&{percentComplete}<=20,"VRT Order Placed",IF(CONTAINS("order vrt files",LOWER({name}))&&{percentComplete}>20&&{percentComplete}<=99.8,"VRT Order in Progress","VRT Order Completed")))

 

 

To get the percentComplete value of the parent task you need to use 

 

{parent}.{percentComplete}

 

in your valueexpression.

 

Regards

Lars