Expand my Community achievements bar.

Nested Task List by Due Date (2 Week Window)

Avatar

Level 2

I am trying to come up with a custom field in a project report that pulls the task title, due date, and status out for tasks on projects that are due within the next 2 weeks but not complete yet.

Here is what I tried but I keep on getting no tasks pulled out even though I know tasks exist within the next 2 weeks or are past due:

column.1.displayname=Column
column.1.sharecol=true
column.1.textmode=true
column.1.value=<div style="padding:5px 5px 5px 5px;border-bottom:2px; background:#cccccc; text-align:center; font-weight:bold; font-size:11pt;border-radius:0px 0px 0px 0px; box-shadow: 0px 0px #858585;"><b>KEY MILESTONES</b></div><div style="padding:3px 3px 3px 3px; border-bottom:0px; background:#f5f5f5; text-align:left; font-size:10pt; border-radius:0px 0px 0px 0px; box-shadow: 0px 0px #858585;"><b>Incomplete (< 10 days out)</b><br>
column.1.valueformat=HTML
column.2.displayname=Column
column.2.listdelimiter=<p>
column.2.listmethod=nested(tasks).lists
column.2.textmode=true
column.2.type=iterate
column.2.valueexpression=IF({plannedCompletionDate}<$$TODAYed+10d,IF({numberOfChildren}=0,IF({duration}=0,IF({percentComplete}<100,(CONCAT("   ◇ ",IF({condition}=0,'<b><font color=03a219>[Green] </font></b>',IF({condition}=1,'<b><font color=e19503>[Yellow] </font></b>',IF({condition}=2,'<b><font color=d30519>[Red] </font></b>',""))),{name}," (Planned: ",{plannedCompletionDate},")"))))))
column.2.valueformat=HTML

Can someone help me fix this to extract tasks not completed within the next 2 weeks?

 

Thank you!

 

4 Replies

Avatar

Level 3

This is a task report that shows tasks due in two weeks.

I group this by Project.

Hope this helps.

 

Task Report Due In Two Weeks:

Filters

ElliotLeson_1-1665058301721.png

Columns

ElliotLeson_2-1665058339116.png

 

 

Avatar

Level 2

Hello Elliot. Thank you for responding to this. I was looking for more of a list format on the project report view in a column list per project.

Avatar

Community Advisor

I would suggest starting with a simpler valueexpression and building up from there so you can see where the issue truly is. Start with the expression itself (I don't want to say formatting isn't possible in a valueexpression, but I don't think formatting is possible in a valueexpression).

 

0) stop sharing the columns, you'll want to see this result by itself for a while.

1) try: if percent complete < 100, display name and planned completion date.

2) if that works, add the "if duration =0" in front of it and see if that works.

3) then add number of children.

4) then add planned completion date < today + 10 days

 

If you get stuck on even the basic valueexpression, at least you'll be able to post a more specific question. After you have the basic valueexpression working, move on to putting your concats in, one at a time.

 

If your concats work, you can try the formatting one more time (again, just try adding one color at a time) -- at this time, I think you may have to make a decision about how important the formatting is, as I don't really believe valueexpressions allow for this (always happy to be proven wrong though).

 

After you get something working, you can put the sharecol back in.

Avatar

Community Advisor

I agree with Skye that you cannot embed CSS styling within a valueexpression as a cheat to conditionally format items in a collection.

If anyone can demonstrate differently, I'd love to see it. 

If you like my content, please take a moment to view and vote on my Idea Requests: https://tinyurl.com/4rbpr7hf