Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

MattMc2
MattMc2
Offline

Badges

Badges
0

Accepted Solutions

Accepted Solutions
0

Likes Received

Likes Received
40

Posts

Posts
38

Discussions

Discussions
23

Questions

Questions
15

Ideas

Ideas
23

Blog Posts

Blog Posts
0
Top badges earned by MattMc2
Customize the badges you want to showcase on your profile
Re: Group milestone tasks by quarter in project report using text mode. - Workfront 02-12-2021
For the benefit of anyone who might be following along and/or interested:I adjusted the formula slightly to remove wasted white space. The original formula resulted in "blank" lines where there were no milestones. I removed the title "column" and added a space after the entry that only comes into play if there is a line added. column.4.sharecol=truecolumn.4.textmode=truecolumn.4.value= [removed this title line]column.4.valueformat=HTML column.5.displayname=Next Quarter (Q+1)column.5.listdelimite...

Views

35

Likes

0

Replies

0
Re: Group milestone tasks by quarter in project report using text mode. - Workfront 01-12-2021
Thanks, Doug! I didn't know about cleartime. That [stacked time addition] looks really handy! I wish I'd known about that sooner It would have saved me a lot of headaches on this and other reports 😄

Views

35

Likes

0

Replies

0
Re: Group milestone tasks by quarter in project report using text mode. - Workfront 01-12-2021
Ok, I think I figured out. Use less than the beginning of the following quarter for the end range column.8.valueexpression=IF({plannedCompletionDate}>$$TODAYbq+1q,IF({plannedCompletionDate}<=$$TODAYbq+2q,IF({numberOfChildren}=0,IF({duration}=0,(CONCAT(" ‚óá ",IF({condition}=0,' [Green] ',IF({condition}=1,' [Yellow] ',IF({condition}=2,' [Red] ',""))), {name}," (Planned: ",{plannedCompletionDate},")")))))) instead of less than the end of the quarter column.8.valueexpression=IF({plannedCompletionDa...

Views

35

Likes

0

Replies

0
Re: Group milestone tasks by quarter in project report using text mode. - Workfront 01-12-2021
Thanks, Doug! I was afraid of that. I went ahead and built it out and have one minor issue. If a date falls on the last day of the quarter it is excluded. I suspect it has to do with the "less than end of quarter" rule. I am not sure how to do "less than or equal to" instead of just "less than". e.g.I have: IF({plannedCompletionDate}<$$TODAYeq+2qI think need: IF({plannedCompletionDate}<=$$TODAYeq+2q Any suggestions on how to do this? column.5.displayname=Key Milestones (Grouped)column.5.sharecol...

Views

35

Likes

0

Replies

2
Group milestone tasks by quarter in project report using text mode. - Workfront 30-11-2021
Hi Workfront gurus, I have a text mode report that pulls in milestones (zero duration tasks) and groups them according to planned completion date. I can do this using relative dates (greater than, less than today) but I want to group for specific quarters (absolute dates). For example, I'd like to group by Q1 2022, Q2 2022 etc but I can't figure out how to do it. This is what I have for the relative dates. Any help or guidance on how to change this for specific date ranges would be greatly appre...

Views

35

Likes

0

Replies

6
Re: [Project Report] How to list nested tasks in chronological order. - Workfront 13-08-2021
Oh, well. It was worth a shot. We'll just have to direct folks into the schedule for an ordered list. Thanks for taking the time to look at this for me!

Views

23

Likes

0

Replies

0
Re: [Project Report] How to list nested tasks in chronological order. - Workfront 12-08-2021
Thanks, Skye. I was afraid it might be something like that but secretly hoped someone had a cunning workaround. Limitations of a collection View: You cannot control the order in which collection data is displayed.

Views

23

Likes

0

Replies

2
[Project Report] How to list nested tasks in chronological order. - Workfront 12-08-2021
Hi Folks, I have created a project report that pulls in tasks (i.e. milestones: zero duration tasks with no sub tasks) and groups them based on based on Complete or Incomplete status but for the life of me I cannot figure out how to get them to list chronoligically. Can anyone help? column.18.displayname=Columncolumn.18.sharecol=truecolumn.18.textmode=truecolumn.18.value=Key Milestones (Incomplete)column.18.valueformat=HTMLcolumn.19.displayname=Columncolumn.19.listdelimiter=column.19.listmethod=...

Views

23

Likes

0

Replies

4
Re: ValueExpression Syntax Help - Workfront 18-05-2021
Awesome, thanks Anthony! It seems obvious now - I was down a rabbit hole messing about with "Mod=notin". Thanks, again!

Views

33

Likes

0

Replies

0
Re: ValueExpression Syntax Help - Workfront 17-05-2021
Thank you, Anthony. This is a really well laid out answer - I have used your tips before (e.g. sharecol). Quick Question, how would you rewrite scenario if status did not equal CPL?

Views

33

Likes

0

Replies

2