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 pl...

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 

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,'<b><font color=03a219>...

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....

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 g...

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!

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.

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.displa...

Awesome, thanks Anthony! It seems obvious now - I was down a rabbit hole messing about with "Mod=notin". Thanks, again!

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?