Expand my Community achievements bar.

Interested in applying to or sharing a Workfront-related job opportunity? Check out the Workfront Job Board!

Two tasks with dates on the same line in a report

Avatar

Level 4

Hello!  I am trying to create a report and having an issue on how to acheive it.

I am needing to have two tasks with their due dates on the same line so I can easily pull a comparision report.

So the columns would be:

Project Name, Project Owner, Task Name 1, Due Date of Task Name 1, Task Name 2, Due Date of Task Name 2, Cacluation of due date differences

 

Thanks,

Brandi

2 Replies

Avatar

Level 2

I've used an expression like this with a collection column to Isolate a particular task from a list

 

valueexpression=IF(CONTAINS('First Word',{name})=true,IF(CONTAINS('Second Word',{name})=true,IF(CONTAINS('Third Word',{name})=true,CONCAT("Condensed Task Name - ",{plannedCompletionDate})," ")," ")," ")

 

There are some limitations. For each contains statement, you can only use one capitol sensitive word per statement. Also I had issues trying to nest more than 3-4 if statements. You would need to use this statement for each column. I don't think you would be able to create a calculation for the due date difference using this code. This would only solve your Task Name 1, Task Name 2 column problem

Avatar

Community Advisor

Have you considered sharing columns? You can share columns to show multiple pieces of data in 1 column...https://experienceleague.adobe.com/docs/workfront/using/reporting/reports/custom-view-samples/view-m...

page footer