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"?