Expand my Community achievements bar.

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