Nested Task List by Due Date (2 Week Window) | Community
Skip to main content
T
thisisxeney
Level 2
October 6, 2022
Question

Nested Task List by Due Date (2 Week Window)

  • October 6, 2022
  • 2 replies
  • 1067 views

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!

 

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

2 replies

ElliotLeson
ElliotLeson
Level 3
October 6, 2022

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

 

 

T
thisisxeneyAuthor
Level 2
October 6, 2022

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.

skyehansen
Community Advisor and Adobe Champion
skyehansenCommunity Advisor and Adobe Champion
October 6, 2022

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.

    William
    Community Advisor
    WilliamCommunity Advisor
    Community Advisor
    October 7, 2022

    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
    Terms & ConditionsAccessibility statement

    Loading footer...