Text Mode Reporting with multiple task statuses | Community
Skip to main content
KayleeRichard
KayleeRichard
Level 2
April 5, 2024
Solved

Text Mode Reporting with multiple task statuses

  • April 5, 2024
  • 2 replies
  • 782 views

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! 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by lgaertner

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

2 replies

KayleeRichard
KayleeRichardAuthor
Level 2
April 6, 2024

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

lgaertner
lgaertnerAccepted solution
Level 9
April 8, 2024

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

Terms & ConditionsAccessibility statement

Loading footer...