Grouping: organize list results by a calculated value common to all objects in the grouping
You might want to view your tasks grouped by Percent Complete in ranges of 0-25, 26-50, 51-75, 75-99, and 100. You can create a grouping using text mode to do this.
Access requirements
You must have the following access to perform the steps in this article:
*To find out what plan, license type, or access you have, contact your Workfront administrator.
Organize list results by a calculated value common to all objects in the grouping
To apply this grouping to a list of tasks:
-
Go to a list of tasks.
-
From the Grouping drop-down menu, select New Grouping.
-
Click Switch to Text Mode.
-
In the available space, add the following code:
code language-none textmode=true<br>group.0.valueexpression=IF({percentComplete}>=0&&{percentComplete}<=25,'0-25%',IF({
code language-none percentComplete
code language-none }>25&&{percentComplete}<=50,'26-50%',IF({percentComplete}>50&&{percentComplete}<=75,'51-75%',IF({percentComplete}>75&&{percentComplete}<=100,'76-100%',''))))<br>group.0.linkedname=direct<br>group.0.valueformat=doubleAsString<br>group.0.namekey=percentComplete
-
Click Done, then Save Grouping.
recommendation-more-help
5f00cc6b-2202-40d6-bcd0-3ee0c2316b43