Add Colours to a column that pulls in specific task names | Community
Skip to main content
MattEl5
MattEl5
Level 3
November 18, 2024
Question

Add Colours to a column that pulls in specific task names

  • November 18, 2024
  • 1 reply
  • 617 views

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! 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

Sven-iX
Community Advisor
Sven-iXCommunity Advisor
Community Advisor
November 19, 2024

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
MattEl5Author
Level 3
November 26, 2024

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
Community Advisor
Doug_Den_Hoed_AtAppStoreCommunity Advisor
Community Advisor
November 28, 2024

 

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

Terms & ConditionsAccessibility statement

Loading footer...