Expand my Community achievements bar.

Join us for our Coffee Break Sweepstakes on July 16th! Come ask your questions or share your use cases on Creative Briefs for a chance to win a piece of Workfront swag!
SOLVED

Need column calc to filter out results of another custom column calc

Avatar

Level 3

I created a new column to determine if projects were created with a new project template, or an old project template (if statement).  Our new project template has 19 tasks on it, but the old one had a lot more. 

 

This is the calculation I'm using::

displayname=Less than 20 Tasks = New Template
sortType=desc
textmode=true
totalTaskCount_Mod=lt
valueexpression=IF({totalTaskCount}>20,"Old Template","New Template")
valuefield=totalTaskCount
valueformat=HTML

 

This works great.  However now I need to filter out anything that is classified as "Old Template".  Since this is setup as a custom column calc, I can't format on it.  I also can't group it. 

 

How do I filter out all the items that are classified as created with the "old template"?

DeniseCo1_0-1673484143532.png

 

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Question, is the new and old template the same template just revised? If they are two different templates, even if one is now deactivated, you could use a project report and group by template?

If this helped you, please mark correct to help others : )

View solution in original post

1 Reply

Avatar

Correct answer by
Community Advisor

Question, is the new and old template the same template just revised? If they are two different templates, even if one is now deactivated, you could use a project report and group by template?

If this helped you, please mark correct to help others : )