Hi Sujatha,   If you want to group by a multi-select field in a report, the below text mode for your grouping should do it:   group.0.displayname=Geo Performance group.0.valueexpression={DE:Geo Performance Field Name} group.0.valueformat=HTML textmode=true   However, please note that you will not be...

No problem Vin. If this solved your problem, please mark it as a Correct Answer so that others know that the solution works.

Hi,   The only way to achieve this would be to replicate the calculation from your column into a custom field and attach it to the objects you report on.    It's not possible to chart based on values created in a calculated column as these values don't exist in the database (they are just calculated...

Hi Nick,   The below should do it. This will return all programs that have projects within them in active status, regardless of whether or not there are other projects in a closed status within that program   EXISTS:a:$$EXISTSMOD=EXISTS EXISTS:a:$$OBJCODE=PROJ EXISTS:a:programID=FIELD:ID EXISTS:a...

No Problem.   Yes, the actual start date is captured as soon as the first task is marked as In Progress, even if the project isn't "active". To record an active date there needs to be some sort of an action or trigger in Workfront for it to capture the date. My recommendation would be that either a ...

Hi Vin,   Try WORKMINUTESDIFF instead, then divide by 60 to get the number of hours. The below textmode should do it   valueexpression=ROUND(DIV(WORKMINUTESDIFF({actualCompletionDate},{actualStartDate}),60),2) Best Regards, Rich. 

Hi Chank,   This is possible, but it depends how you are measuring when the project was turned active. A couple of options spring to mind:   Natively in Workfront, there is a field called actualStartDate which will record when the project first started to be worked on (measured as the date/time that...

Hi Angie,   I think you want Update feeds (located in Setup >> Interface >> Update Feeds).   Unfortunatley this area cannot be customised at the group level, it's a global change.   Best Regards, Rich. 

Hi Cori,   What data format is your duration estimate field? It needs to be a number format in order for the calculation to work. My calculation assumes that the duration estimate is a number of days.    If your users are typing the duration as text (i.e., "3 months"), Workfront wont be able to read...

Hi Cori,   You could achieve this with a calculated date field that subtracts the duration estimate from the due date. The calculation would look something like this:   ADDWEEKDAYS({DE:Due Date},-{DE:Duration Estimate}) Best Regards, Rich.