Add Colours to a column that pulls in specific task names

[MattEl5]

Hey folks!! 

Wracking my brain over this one, I am sure theres a way to do it, but my syntax is probably not exact. 
The column is called "Strategic Planning Meeting" 
The task is called "Planning | Strategic Planning Meeting" 
What i want it to do is turn the box grey if the date is less than today (yesterday and earlier) 
*bonus points if you can also get it to turn Green when it is today!*

I think im having problems with it identifying the task rather than the whole project once it comes down to changing colours. 

displayname=Strategic Planning Meeting
listdelimiter=<p>
listmethod=nested(tasks).lists
shortview=true
styledef.case.0.comparison.icon=false
styledef.case.0.comparison.leftmethod=plannedStartDate
styledef.case.0.comparison.lefttext=plannedStartDate
styledef.case.0.comparison.operator=lt
styledef.case.0.comparison.operatortype=date
styledef.case.0.comparison.righttext=$$TODAY
styledef.case.0.comparison.trueproperty.0.name=bgcolor
styledef.case.0.comparison.trueproperty.0.value=e8e8e8
styledef.case.0.comparison.truetext=
textmode=true
type=iterate
valueexpression=IF(CONTAINS("Planning | Strategic Planning Meeting",{name}),{plannedStartDate},"")
valueformat=HTML

I tried copying the Valueexpression bit and replacing the "plannedStartDate" with it, but it didnt like that. 

Any ideas greatly appreciated!! On go the efforts to try and understand the project vs task complexities! 

[Sven-iX]

Hi @MattEl5 

I haven't tried this but I doubt this will work: 

The style configuration operates on the object of the row - in your case, the PROJ. 

What you're doing in that cell is iterating over the project tasks (very low performing at scale) and printing out one specific task. 

That task's properties have nothing to do with the project - so you can't color in the cell if "one result of the iteration has a date that is...". 

your options: 

1. do a task report. 

2. use Fusion/API to set a hidden field at the project for the "Strategic Planning Meeting" plannedStartDate - then you can colorize the cell based on this value.

[MattEl5]

Thanks for answering Sven. 

Tried a couple of things but like you said. i believe its a lost cause without some kind of fusion. thanks! 

[Doug_Den_Hoed__AtAppStore]

Hi @MattEl5,

If you'd consider switching to a Task report and pulling whatever is of interest (read only, mind you) from the Project and adding a Task Level calculated parameter to the tasks of interest, I believe it would be possible to use Advanced Format columns that would achieve the coloring rules you seek without resorting to Fusion.

Regards,

Doug