I think posting what you've been using as a nested IF would help us help you troubleshoot. In theory the syntax for an IF statement looks like this: IF(condition, trueExpression, falseExpression)   So extrapolating here, the nested IF should look like this: IF(condition, trueExpression, IF(condition...

haha I'm sure someone wants something to start based on what day of the week it is. Luckily my users have never gotten that deep into predecessors.

what initially occurs to me is that workfront doesn't have a listing for "w" to mean "week" in the lag types overview: https://experienceleague.adobe.com/en/docs/workfront/using/manage-work/tasks/use-task-predecessors/lag-types   If I wanted to do 2 weeks, I'd indicate it using "10d" and start exper...

hi, I'm not sure if this is old information to you or not, but your current text mode "iterates" (loops through the entire list of users) and for each user gives you the role and the user name. There's no way to group a set of users under one role name unless you break it apart and iterate for all t...

several admins have submitted cases to Support -- I always encourage everyone to do this so Adobe can be aware that it is a widespread issue.   For us, I was able to bring it up on a project report.   Edited to add some workarounds:   * users may download the report and access the data off the sprea...

I dont think this is possible in a layout template report. You should instead consider using a role report and pulling in the column for layout template (or filtering for layout template ID is blank).

I don't think there's an urgent need to remove the existing calculation at this time. Just create a new calculated field and see if it does what you want. If it does, you can assess and make a plan to replace the old field at that time.

please reformat it to be a number if you wish to use the aggregation functions. (you will probably have to recreate the field)

Is your calculated field formatted for text or number? If it was formatted for number, then if you bring it in as a column, there should be an option to aggregate by SUM, no text mode needed. It's in the Column Settings area, under "summarize this column by:"   If the calculated field is formatted a...

it doesn't appear that you've set up your calculated field yet. You would need one on each request to provide the points, that you could then sum up in a report.