


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!
Views
Replies
Sign in to like this content
Total Likes
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
Columns
Views
Replies
Sign in to like this content
Total Likes
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.
Views
Replies
Sign in to like this content
Total Likes
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.
Views
Replies
Sign in to like this content
Total Likes
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.
Views
Replies
Sign in to like this content
Total Likes