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

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