This is a great tip! This is applicable is so many ways! Love it! Simple fix to the "gotcha": IF(ISBLANK({Checkbox Field}),0,SUM(1,SUB(LEN(REPLACE({Checkbox Field},",","**")),LEN({Checkbox Field}))))

It looks like the aggregator code affects groupings only, not parent tasks. However, it works effectively for groupings. Is there a way to essentially apply the same specifications for how it handles aggregated data on the parent task?

I have a task view that I am trying to create. I want to create a column called "Effort" that shows Duration if it is a child task (numberOfChildren = 0) and the Planned Hours if it is a parent task (numberOfChildren > 0) in the same column. The reason is that the Calculated Work setting only allows...

My team uses a template where all tasks are set up as Calculated Work tasks. We also do not use a typical 8-hour workday, so we enter the duration of all tasks as hours (e.g., Duration = 2 hrs) and therefore the Planned Hours matches automatically (e.g., Planned Hours = Duration = 2 hrs, assuming a ...

My overall desire is to have initiative requirements that apply to a given project be listed in a custom report that appears on the lefthand navigation of the project. Here is what I have: Regular projects. These projects contain a custom field called "Initiatives" where one or multiple initiatives ...

I am trying to create a matrix report where the rows are rolling up information from subtasks to a special parent task called M01, M02, M03, ... (through a custom field which I already have in place) and the columns are users on the project. I desire for the values to be the planned hours multiplied...

Ah! Alas! That was it! Apparently, I shared the portfolio with a high-level group and that gave inherited permissions to dozens of people so that everyone in that group could see all projects in that portfolio! Removing the group did the trick! I have now learned to be as minimalistic as possible wh...

I have several projects set up, and I have several project managers. I desire to allow the project managers to see only projects that belong to them (either project that they own or that have been shared with them). Basically, a project manager does not need to see other projects from other project ...

I would love to hear back on this one too! There are so many things that I would like to see grouped by the highest parent group.

If I set the Cost Type of a task to be Role Hourly but the Job Role has a blank for the Cost/Hr, does Workfront calculate the task's actual cost based on the Cost Per Hour of the user who logged hours, or does it take the cost to be $0? More broadly, how does the user's Cost Per Hour interact with t...