Expand my Community achievements bar.

Join us LIVE in San Francisco on November 14th for Experience Makers The Skill Exchange. Don't miss out on this free learning event!
SOLVED

Two tasks with dates on the same line in a report

Avatar

Level 5

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

1 Accepted Solution

Avatar

Correct answer by
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...

If this helped you, please mark correct to help others : )

View solution in original post

2 Replies

Avatar

Level 3

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

Correct answer by
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...

If this helped you, please mark correct to help others : )