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:
| table 0-row-2 1-row-2 2-row-2 3-row-2 layout-auto html-authored no-header | |
|---|---|
| Adobe Workfront plan | Any |
| Adobe Workfront license* |
New:
Current:
|
| Access level configurations |
Edit access to Reports, Dashboards, Calendars to modify a report Edit access to Filters, Views, Groupings to modify a filter |
| Object permissions | Manage permissions to a report |
*For information, see Access requirements in Workfront documentation.
Group projects by Entry Date
To apply this grouping:
-
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. -
Click Report Actions > Edit.
-
From the Grouping tab, click Add Grouping.
-
Click Switch to Text Mode.
-
Remove the text in the Group by area.
-
Replace the text with the following code:
code language-none group.0.linkedname=direct group.0.name=Project Entry 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")) group.0.valueformat=atDateAsMonthString textmode=true -
Click Done > Save Grouping.
-
(Optional) Update the name of the grouping, then click Save Grouping.