Expand my Community achievements bar.

SOLVED

Webinar | System Admin Essentials: Foundations of Project Templates (May 17, 2023)

Avatar

Employee

Project templates allow you to create specific, repeatable processes so you can avoid “reinventing the wheel,” but does everything need to be a template? How many templates is too many? And what’s the best way to update them?

In this on-demand webinar, originally broadcast on May 17, 2023, Kiersten Kollins (@Kiersten_K), Sr. Marketing Operations Technologist and System Admin at DSW, and Jen Desmond (@JenniferDe5), Customer Success Architect at Adobe Workfront (and former customer), walked through:

  • Why templates are important
  • Template development best practices
  • Common template pitfalls to avoid (don’t forget task constraints!)
  • What our speakers wish they had known when they were first implementing templates
  • And more

You can view the recording here and a copy of the slides is attached. Have questions for our speakers? Tag them in a comment below.

 

 

WF_ON24_LandingPage_AdminEssentials_Gray_2023.png

1 Accepted Solution

Avatar

Correct answer by
Employee

Hello everyone and thank you for joining us yesterday!

As promised, here is a kick-start for the report shown on slide 15, Recommended task report for auditing user created tasks.

And guess what? It's even better than the screenshot in the slide! Not only does it have the columns for Template Task Name, Template Task Template Name, and Project Template, but I've also thrown in 2 variance columns: Duration Variance and Hours Variance

Those columns look at the difference between Planned Hours and Actual Hours (to get the Hours Variance), and Duration and Actual Duration (to get the Duration Variance). If you see a negative number, it means that task had fewer hours or a shorter duration than you planned! This will help you evaluate your planned hours and durations against reality to analyze and improve your templates.

Note that there's no filter on this report, so I recommend whittling the results down, possibly by template, but do it any way that's helpful for you!

For help importing a kick-start, visit: Import data into Adobe Workfront using a Kick-Start template

Have fun!

View solution in original post

18 Replies

Avatar

Level 2

@daniel M, if you have a report for showing deleted tasks from a project (with a template) can you please share your columns and filters for those of us trying to create this rather quickly to help with using it now.

Samantha

Avatar

Level 1

Hi Samantha, 

You can access your recently delete tasks, projects, template, issues or documents by simply going to Setup > Recycle Bin > Recently Deleted.

There you will be able to access all what you're looking for. I hope this helps.

Tom

Avatar

Level 2

Yes, I use the recycle bin often to restore items that others have accidently deleted.  Mainly proofs that are on top of a previous version and they deleted all of them by mistake instead of just the last version.

I was hoping for the report versions for inline editing to be easier or to show leadership.

Avatar

Level 1

Hi @KristinFarwell ,

 Link to documents in a project or task view


Thank you for the information. To follow up from my question, can you give us the text-mode code for how to view the document title/URL of doc in Project tasks view. Our company has a lot of tasks in our projects and it would be very helpful to identify which doc is link to the task. 

Here is the resource I found online, but that does not work. 

 

Thank You.

 

Source: https://www.leappoint.com/blog/top-10-workfront-tips/

[css autolinks=”false” classname=”myclass” collapse=”false” firstline=”1″ gutter=”true” highlight=”” htmlscript=”false” light=”false” padlinenumbers=”false” smarttabs=”true” tabsize=”4″ toolbar=”true”]displayname=Documents
listdelimiter=
listmethod=nested(documents).lists
textmode=true
type=iterate
valueexpression=CONCAT({name}, – “https://<domain>.my.workfront.com/document/view?ID=”,{ID},”; “)
valueformat=HTML[/css]

Avatar

Employee

Hi @t_alexander !

 

This is close! To get a column with the task-level documents in a project list, try this:

 

displayname=Task Documents
listdelimiter=
listmethod=nested(documents).lists
textmode=true
type=iterate
valueexpression=CONCAT({name}," - https://[your domain here].my.workfront.com/document/view?ID=",{ID})
valueformat=HTML

 

This will give you the name of the document, a hyphen, and then a clickable link to it. 

 

Hope that helps! 

Avatar

Level 2

Thank you so much for the webinar today! 

Question for @Kiersten_K: I am just dying to know how you created this report: 

 

Screenshot 2023-05-17 at 11.54.09 AM.pngI am currently working on a project for our VP and a similar report would make all of the difference in our communications! I haven't been able to figure out how to put together a Gantt chart like this one. Thank you! 

 

 

 

 

 

 

 

Avatar

Level 9

You got it! Let me gather all the steps I took and I will follow back up. 

 

-Kiersten

Avatar

Level 9

@JenAg1  - Following up with the steps to create the milestone report. I hope this can work for your team!  

 

Steps to create a milestones report

 

  1. Start with a Project report type.
  2. Set up your report filters for what you want to see on the report.
    • We did a filter that would pull in Project Status for Draft and Current statuses. We pulled in Draft so our team could pre-plan and layer in work with projects that were already being worked on.
    • In my example, we had one additional filter that pulled a custom form field that was a "tag". For example, we would tag the project as "Holiday 2022" and it would only pull in these projects with it.
  3. Add columns or remove any default columns as needed.
  4. Save the report.
  5. Once you have it saved, click on the Gantt chart icon near the upper right side of the report.Screenshot 2023-05-19 at 1.06.18 PM.png
  6. Now that you have this set up, here is where the magic happens.
    1. Click on the Options gear icon near the upper right corner.
    2. You will see a drop down check list pop up. Turn on the option(s) that you would like to see on the Gantt chart view.
      1. If you set up a Milestone Path and attach the milestones to your tasks, turn on the Milestone Diamonds
        • Screenshot 2023-05-19 at 1.06.34 PM.png
  7. Your Gantt chart will now display what you have selected from the options menu.
    • Screenshot 2023-05-19 at 1.07.24 PM.png
      • If you have those Milestone Diamonds turned on, you can hover over a diamond and see what the task is and the date.
        • Screenshot 2023-05-19 at 1.08.02 PM.png
  8. We did have some issues with printing to a PDF due to shear volume of work that we have at this time, so we did need to screenshot our report and stitch the screenshots together in a 1 pager view for our leaders, but the time it took to do this was nothing in comparison when the team had to manage it Excel back in the day. The report is also awesome for meetings and when timelines are being adjusted during the meeting, you can quickly refresh the report and see those changes immediately.

 

Avatar

Level 1

Thank you for a great webinar yesterday. It was very interesting and useful. I'm currently the only person who has created templates in our instance of Workfront as a system admin, so I seem to be notified every time someone uses a template to set up a project. How do I stop that from happening? 

 

Thanks!

Adele

Avatar

Employee

Hi @Adele_J !

 

If you've listed yourself as the Template Owner, you'll be listed as Project Owner of all resulting projects. If the Project Owner changes to someone else, you'll still be listed in the People tab (on the Project Team), and you'll keep getting notifications for Projects I'm On. If you want to stop receiving notifications on those projects, you'll have to remove yourself from the People tab.

 

Generally, we suggest leaving the Template Owner blank unless the owner of the template wants to automatically own all of the resulting projects and keep getting notifications on them .

 

Check out this article on how to Manage the Project Team.

Avatar

Correct answer by
Employee

Hello everyone and thank you for joining us yesterday!

As promised, here is a kick-start for the report shown on slide 15, Recommended task report for auditing user created tasks.

And guess what? It's even better than the screenshot in the slide! Not only does it have the columns for Template Task Name, Template Task Template Name, and Project Template, but I've also thrown in 2 variance columns: Duration Variance and Hours Variance

Those columns look at the difference between Planned Hours and Actual Hours (to get the Hours Variance), and Duration and Actual Duration (to get the Duration Variance). If you see a negative number, it means that task had fewer hours or a shorter duration than you planned! This will help you evaluate your planned hours and durations against reality to analyze and improve your templates.

Note that there's no filter on this report, so I recommend whittling the results down, possibly by template, but do it any way that's helpful for you!

For help importing a kick-start, visit: Import data into Adobe Workfront using a Kick-Start template

Have fun!

Avatar

Community Advisor

 

Thanks Jen, excellent topic, excellent presentation!

 

I agree that there are several (painful) reasons that usually dissuade people from doing modifying Templates. Imagine, for example, adding a new valuable section of tasks (e.g. a "QA Review") to an existing template:

 

  • modifying the Template itself isn't too bad (e.g. new "QA Review" task at the right spot, with its 5 sub-tasks, all sensibly linked ASAP, each with the right duration, assigned to the right role, with the QA Review parent linked via predecessor to the appropriate task earlier in the workplan)
  • going forward, new Projects that are then created via that modified Template automatically include all of the above, which is great
  • but for existing "in flight" Projects that were created from the Template prior to the change...huh...not so easy
  • practically, it's common to leave them as is, and accept that they'll be excluded from any analysis on that new portion of the Template (since they lack those Tasks)
  • opportunistically (or under duress), those in flight Projects still at the stage that they would benefit from having the modification enough to warrant being updated can be done...but only manually, either by repeating the same steps on each Project as were done on the Template (yucky), or by creating and inserting a "small" Template that encapsulates only those changes and then tweaking them for things such as predecessors (still pretty yucky)
  • historically, I've observed that these situations often lead to Template Paralysis, with SysAdmins and Business Owners struggling to weigh the cost benefits, and usually resigning to defer such changes and instead catch it next time

 

If that conundrum sounds familiar, I invite you to consider our Sync Template solution, which can free you from analysis paralysis on templates and instead boldly use them to create projects (even if you're not positive that they are ready), periodically adapt the Template as things change, then synchronize those adjustments out to the In Flight Projects of interest (via any Project filter you define).

 

Regards,

Doug

 

 

P.S. Doug_Den_Hoed__AtAppStore_1-1684436619694.png @JenDesmond, if you're interested in a demo sometime, I'd love the opportunity to explore it with you to see if I can sway you to the Dark Side (and if so, perhaps run a follow-up session someday). 

 

Doug_Den_Hoed__AtAppStore_0-1684436512319.png

 

Avatar

Employee

Here's a question from the webinar yesterday that I want to answer from Elizabeth:

 

Is there a way to see task planned start on dates to auto update based on when the predecessor actual completes and not the predecessors planned due date?

This is by design. We don't want Workfront automatically changing Planned dates due to progress with predecessors. Why? Think of the knock-on effects on resource management, for one. There would be a need to constantly shift resources. And think about Assignees. Their dates would be constantly shifting! Instead, Workfront leaves it up to the Project Owner to decide if they move Planned dates accordingly depending on what's happening in the project.

That's why there are more date fields to add to your task lists and reports to help you. Projected and Estimated dates (both have Start and Completion) are calculated by the system to take into account fixed Task Constraint and Commit dates (Projected) and the overall analysis of progress (Estimated) to help you better predict when work will start and finish.

Check out this article to learn more: Differentiate between Projected and Estimated Dates

 

Avatar

Community Advisor

 

Excellent points @JenDesmond.

 

For Elizabeth...even without changing the Planned Start Dates of subsequent tasks, there is special property called Handoff Date (and its tagalong cousin, Can Start) that you can leverage to highlight to users that they could start on a Task (early), if they're ready. See this As Soon As Impossible article for more information.

 

Regards,

Doug

Avatar

Level 9

Question from Tiffany from yesterday that I will answer.  

 

How do you batch update through a report? I've not heard that before.

 

Under the Reports area, you are able to create a Template or a Template Task Report. 

Template and Template Task Reports.png

 

I will dive into the Template Task report as this has been a huge game changer for me because it was painful going through templates one by one when we had 80 of them. 

 

Since our team has the same workflow happening across a majority of our templates even though they are for different Marketing Channels, I can quickly make changes to task assignments, durations, planned hours, descriptions, attach a custom form to a task, etc. for like tasks. I will group the like tasks and then click on the pencil icon to make the edits there. 

 

Also, by having these template reports, I can quickly audit like tasks to see if I missed anything for updates.

 

I recommend trying it out to see if it can work for your team. 

 

Avatar

Level 9

Answering a question from Julie from the day of the webinar.

 

Have you found a way to create a report by Milestone?

 

If you are using Milestone Paths, you can certainly create a Task report and pull in the Milestone Name column to see what was attached to that task as a milestone. 

 

You can add a prompt on your report to drill down to a specific milestone.

 

Screenshot 2023-05-19 at 2.44.35 PM.png

 

If you want to see all milestones, just run the report without the prompt and you can group them by the Milestone Name field.

 

Screenshot 2023-05-19 at 2.46.50 PM.png

 

You can take it a step further and create a simple chart as to see what is and isn't being used to re-assess the milestones.

 

Screenshot 2023-05-19 at 2.49.53 PM.png