Expand my Community achievements bar.

Come join us for our Coffee Break this WEDNESDAY on top takeaways from Adobe Summit!

How to show columns if task does not exist

Avatar

Level 2

I am working on a project report that shows tasks from projects in the column view as a list. Here I decided that Task 1 and Task 2 are important for projects but do not occur on every project. I have made a field that says Field 1 Status and Field 2 Status and then they show the task as well as statuses within the same line. I need some assistance making it so that if Task 1 does not exist on the project then it does not show column 1 and column 2 or if Task 2 does not exist it does not show column 3 and 4 in this case.

 

column.1.sharecol=true
column.1.textmode=true
column.1.value=<br><strong>Field 1 Status: </strong>
column.1.valueformat=HTML
column.2.listmethod=nested(tasks).lists
column.2.sharecol=true
column.2.textmode=true
column.2.type=iterate
column.2.valueexpression=IF({name}="Task 1",CONCAT(" * ",{name}, " - " ,{status}, " - ", {percentComplete},"%", " - " ,{plannedCompletionDate}),"")
column.2.valueformat=HTML
column.3.sharecol=true
column.3.textmode=true
column.3.value=<br><strong>Field 2 Status: </strong>
column.3.valueformat=HTML
column.4.listmethod=nested(tasks).lists
column.4.textmode=true
column.4.type=iterate
column.4.valueexpression=IF({name}="Task 2",CONCAT(" * ",{name}, " - " ,{status}, " - ", {percentComplete},"%", " - " ,{plannedCompletionDate}),"")
column.4.valueformat=HTML

0 Replies