DocumentationWorkfrontWorkfront Guide

Grouping: projects by Entry Date

Last update: Tue May 23 2023 00:00:00 GMT+0000 (Coordinated Universal Time)

CREATED FOR:

  • User

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*

Request to modify a grouping

Plan to modify a report

Access level configurations*

Edit access to Reports, Dashboards, Calendars to modify a report

Edit access to Filters, Views, Groupings to modify a grouping

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:

    code language-none 
    group.0.linkedname=direct<br>
    code language-none 
    group.0.name=Project Entry<br>
    code language-none 
    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>
    code language-none 
    group.0.valueformat=atDateAsMonthString<br>
    code language-none 
    textmode=true

  6. Click Save + Close.

recommendation-more-help
5f00cc6b-2202-40d6-bcd0-3ee0c2316b43