Need column calc to filter out results of another custom column calc | Community
Skip to main content
D
DeniseCo1
Level 3
January 12, 2023
Solved

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

  • January 12, 2023
  • 1 reply
  • 431 views

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

 

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by Madalyn_Destafney

    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?

    1 reply

    Madalyn_Destafney
    Community Advisor
    Madalyn_DestafneyCommunity AdvisorAccepted solution
    Community Advisor
    January 26, 2023

    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 : )
    Terms & ConditionsAccessibility statement

    Loading footer...