Hi Justin, If you just need the project count it would be easier to create a project report and group by program. This will allow you to: (a) get a count of projects by program, and (b) create a bar chart to visually display the data.- Matt

Hi Michael, Regarding bullet #1This is very interesting to me as I managed a couple of instances where we reduced the available hours from 8 to 6 (with varying levels of resistance) to allow for indirect work for more accurate resource management and planning. It was not difficult to convince worker...

I LOVED the sessions where Workfront, Workfront Fusion, AEM Assets, and Photoshop/Firefly intersected. I saw a huge opportunity to enable users "self serve" their creative assets. Is there a timeline for when the Photoshop API will be generally available for use in Fusion?

From memory, Frame.IO will eventually replace proof but the two will co-exist for the foreseeable future. On the topic of Frame.IO this was a great teaser on the release of Frame.IO v4.Introducing Frame.IO v4 

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!