IF statement help needed | Community
Skip to main content
JosephDe
JosephDe
Level 2
March 25, 2022
Question

IF statement help needed

  • March 25, 2022
  • 3 replies
  • 921 views

My team is looking to do some data clean up! I'm trying to develop syntax to filter out all programs with projects so the report only shows programs without projects.

Easier said than done, right? -- looks like we'll need to get creative. My thinking is leading me towards an IF statement to filer out projects with names on a program level report. I'm thinking something along the lines of... IF(project:name,ISBLANK) ... but I feel like I'm far off from a functional syntax. Please be gentile here, it's my first time writing IF statements.

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

3 replies

R
RKirk
Level 4
March 25, 2022

Hi Joseph,

When we were doing similar cleanup efforts for Programs, we made a Project report that showed the following:

Then added a Grouping of Program Name and Project Status

and a chart

This let us see really quick which Programs were potentially never used/abandoned/etc.

skyehansen
Community Advisor and Adobe Champion
skyehansenCommunity Advisor and Adobe Champion
March 25, 2022

probably better if you use an exists statement for this one. You can find out more about them here:

https://one.workfront.com/s/document-item?bundleId=the-new-workfront-experience&topicId=Content%2FReports_and_Dashboards%2FReports%2FText_Mode%2Fcreate-complex-text-mode-filters-using-exists-statements.html

I know you mentioned that you were new to IF statements so I'll help you out with how the answer could look:

EXISTS:a:$$EXISTSMOD=NOTEXISTS

EXISTS:a:$$OBJCODE=PROJ

EXISTS:a:programID=FIELD:ID

but I also really encourage you to dig in there and see if you can create variations (for example, how about looking for programs that haven't had new projects created in the past year?). The examples listed in the help article are really useful learning tools if you work through them. Similarly you can pick up more examples, just doing keyword searches on "exists" or "notexists" on this website.

skyehansen
Community Advisor and Adobe Champion
skyehansenCommunity Advisor and Adobe Champion
March 25, 2022

I forgot to add: the above code is plugged into a program report filter. In regular english, it says "hey, if there is a program where no projects have the program listed as their program, please let me know"

Doug_Den_Hoed_AtAppStore
Community Advisor
Doug_Den_Hoed_AtAppStoreCommunity Advisor
Community Advisor
March 25, 2022

Hi Joseph,

In addition to Skye's link, there are also some great EXISTS and NOTEXISTS examples here; and since the particular business rule you're looking for is among many others we've solved for, I invite you to consider our Health Checker solution, which lets you lets you systematically analyze your Workfront instance using key Business Rules to identify, assess, and then deactivate or purge data clutter.

Regards,

Doug

Terms & ConditionsAccessibility statement

Loading footer...