Views
Replies
Total Likes
Bringing this up to the top because it's a good filter, but hoping to find a way to see when was the last time a template was used to create a project -- I can't find a "last used date" field - or "last project this was used for"
I found this idea so I'm thinking what I want isn't possible but getting me any closer to figuring out which templates I can ignore would be great https://one.workfront.com/s/idea/0874X000000oO7mQAE/detail
.
Views
Replies
Total Likes
hey Jill, you will want to add a couple more lines to that exists statement about the project's entry date.
(i.e. Terry's statement says "find me any templates where no projects were created off them". You want one that now says "find me any templates where no projects have been created off them in the past year" -- or whatever your date is. )
And both of these are great filters to have, but they don't cover the concept of sub-templates -- templates applied after a template has already been applied. Any template that was created for the purpose of attaching partway through the project should be carefully labeled or marked in some way so it doesn't accidentally fall prey to these exists statements.
Views
Replies
Total Likes
Ok I'm answering myself because I found a workaround that involves Excel, so not within WF as I hoped, but I have my answer. I make a PROJECT report for a given time period (ie the last year) and then I have a column that shows which template was used on each project. Then I export to Excel and pivot table and voila, there I have it, all the templates used in the last year.
Views
Replies
Total Likes
Views
Likes
Replies