TIP: Create a Spring Cleaning Project Report | Community
Skip to main content
Doug_Den_Hoed__AtAppStore
Community Advisor
Doug_Den_Hoed__AtAppStoreCommunity Advisor
Community Advisor
February 8, 2023

TIP: Create a Spring Cleaning Project Report

  • February 8, 2023
  • 1 reply
  • 1099 views

Hi Folks,

 

I had an interesting request come up today, so thought I'd share the punchline: the Project report filter below will return each Current Project with at least one Open Task assigned to the currently logged in User and Can Start and is Not Complete, ordered by Project Completion Date, ascending (i.e. oldest first).

 

So! When Spring Cleaning fever hits, I invite you to

 

  • create a Project report with this filter (sorted by Project Completion Date, ascending)
  • pop it on a dashboard
  • share the dashboard with your users, and
  • challenge them to "work down" through any Golden Oldies until they've caught up with what really is Current

Regards,

Doug

 

 

EXISTS:a:$$EXISTSMOD=EXISTS EXISTS:a:$$OBJCODE=TASK EXISTS:a:actualCompletionDate_Mod=isnull EXISTS:a:assignedToID=$$USER.ID EXISTS:a:assignedToID_Mod=eq EXISTS:a:canStart=true EXISTS:a:canStart_Mod=eq EXISTS:a:projectID=FIELD:ID status=CUR

 

 

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

    1 reply

    Ross_Barton
    Ross_Barton
    February 14, 2023

    @doug_den_hoed__atappstore Thanks for this!

     

    When I use this filter it seems to only reference tasks with a single assignee. Can this text mode be modified so that if the logged-in user is one of the assigned users, it would return the project?

     

    I've been trying to determine a way to provide our users with a project list that only includes projects where they are assigned to future/incomplete tasks. As soon as all of their tasks as complete, the project would fall off of their list (and reappear if we added them in the future). I believe the logic you've provided is exactly what I've been looking for, but I think it comes down to assignment users vs assigned user. 

    Doug_Den_Hoed__AtAppStore
    Community Advisor
    Doug_Den_Hoed__AtAppStoreCommunity AdvisorAuthor
    Community Advisor
    February 14, 2023

     

    Hi Ross,

     

    I invite you to give this version a shot, which goes "one step down", to the 1:many assigments object you are after:

    EXISTS:a:$$EXISTSMOD=EXISTS EXISTS:a:$$OBJCODE=TASK EXISTS:a:actualCompletionDate_Mod=isnull EXISTS:a:assignments:assignedToID=$$USER.ID EXISTS:a:assignments:assignedToID_Mod=eq EXISTS:a:canStart=true EXISTS:a:canStart_Mod=eq EXISTS:a:projectID=FIELD:ID status=CUR

    Regards,

    Doug

    Ross_Barton
    Ross_Barton
    February 14, 2023

    This is game-changing for us – thank you! 

     

    Would you mind sharing how I could sort it alpha by project name vs project completion date?

    Terms & ConditionsAccessibility statement

    Loading footer...