Project Report: Task Collection Text Mode for tasks planned in the next 2 weeks | Community
Skip to main content
MoniqueEvans
Community Advisor
MoniqueEvansCommunity Advisor
Community Advisor
October 2, 2024
Solved

Project Report: Task Collection Text Mode for tasks planned in the next 2 weeks

  • October 2, 2024
  • 3 replies
  • 1011 views

Hi Community! Hoping someone can put me out of my misery and help me tweak my text mode code.

I have a project report want to include a column that is a task collection; however, I only want to show tasks (not parents) planned for the next 10 days (2 weeks) and aren't yet completed. Below is the current text mode that works, but it shows all tasks not completed and I need to add in a "< Today + 10d" qualifier

 

displayname=Tasks Due in Next 2 Weeks listdelimiter=<p> listmethod=nested(tasks).lists textmode=true type=iterate usewidths=true valueexpression=IF({numberOfChildren}=0,IF(ISBLANK({actualCompletionDate}),CONCAT({plannedCompletionDate}," - ",{name}))) valueformat=HTML width=300
    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by Sven-iX

    Hi @moniqueevans 

     

    you're so close! 

    Here's the text mode value expression: 

    valueexpression=IF({numberOfChildren}=0 && ISBLANK({actualCompletionDate}) && DATEDIFF({plannedCompletionDate}, $$TODAY)<11,CONCAT({plannedCompletionDate}," - ",{name}),"")

     

    Translated: Show the task if 

    • it's not a parent
    • has no actual completion date
    • it's planned completion date is less than 11 days from NOW

    3 replies

    KatherineLa
    Community Advisor
    KatherineLaCommunity Advisor
    Community Advisor
    October 3, 2024

    Give this edit a try. That will also give you overdue tasks in the past as well as it's written, FYI.

     

    valueexpression=IF({numberOfChildren}=0,IF({plannedCompletionDate}<$$TODAY+10d,IF(ISBLANK({actualCompletionDate}),CONCAT({plannedCompletionDate}," - ",{name}))))

     

    S
    Sujatha_TS
    Level 4
    October 3, 2024

    Hi Moni, I might be wrong.

    My understanding is this might need another valueexpression for planned completion date adddays formula with $$today to +10 days. However, when I tried one valueexpression mode replaced with other showing either dates or task names. 

    Here is what I tried - I used the task name valueexpression formula above and used a filter for planned completion date between $$TODAY to $TODAY+10d. 

     

    I would love to see if there is an alternate option. 

    Regards, Sujatha 

    Sven-iX
    Community Advisor
    Sven-iXCommunity AdvisorAccepted solution
    Community Advisor
    October 3, 2024

    Hi @moniqueevans 

     

    you're so close! 

    Here's the text mode value expression: 

    valueexpression=IF({numberOfChildren}=0 && ISBLANK({actualCompletionDate}) && DATEDIFF({plannedCompletionDate}, $$TODAY)<11,CONCAT({plannedCompletionDate}," - ",{name}),"")

     

    Translated: Show the task if 

    • it's not a parent
    • has no actual completion date
    • it's planned completion date is less than 11 days from NOW
      MoniqueEvans
      Community Advisor
      MoniqueEvansCommunity AdvisorAuthor
      Community Advisor
      October 3, 2024

      I appreciate you SO MUCH!!!

      I tried so many equations and DATEDIFF never came to mind.

      Terms & ConditionsAccessibility statement

      Loading footer...