Expand my Community achievements bar.

Do you have questions about the migration to Adobe Business Platform? Come join our upcoming coffee break and ask away!

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