Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

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 Reply

Avatar

Level 8

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?