Grouping: projects by Entry Date

In this custom project grouping, you can display projects grouped by their Entry Date values.

Each grouping shows projects with an Entry Date within:

  • The last 30 days
  • 30-60 days
  • 60 days or older

Access requirements

You must have the following access to perform the steps in this article:

Adobe Workfront plan*

Any

Adobe Workfront license*

Plan

Access level configurations*

Edit access to Reports, Dashboards, Calendars

Edit access to Filters, Views, Groupings

Note: If you still don't have access, ask your Workfront administrator if they set additional restrictions in your access level. For information on how a Workfront administrator can modify your access level, see Create or modify custom access levels.

Object permissions

Manage permissions to a report

For information on requesting additional access, see Request access to objects .

*To find out what plan, license type, or access you have, contact your Workfront administrator.

Group projects by Entry Date

To apply this grouping:

  1. Go to an existing project report, or create a new project report.
    For more information about creating a report, see the article Create a custom report.

  2. From the Grouping tab, click Add Grouping.

  3. Click Switch to Text Mode.

  4. Remove the text in the Group your Report area.

  5. Replace the text with the following code:

    group.0.linkedname=direct<br>
    
    group.0.name=Project Entry<br>
    
    group.0.valueexpression=IF(ABS(DATEDIFF({entryDate},$$TODAY))<=30,"Last 30 Days",IF(ABS(DATEDIFF({entryDate},$$TODAY))>30&&ABS(DATEDIFF({entryDate},$$TODAY))<=60,"30-60 Days","Older than 60 days"))<br>
    
    group.0.valueformat=atDateAsMonthString<br>
    
    textmode=true
    
  6. Click Save + Close.

On this page