Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

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