Counting functions are extremely limited in Workfront native reporting, and there is no way to do what you are trying to do in a view. I suggest reviewing the documented Calculated data expressions article to see what functions are available to use - you won't find "COUNT" in that list. The only way...

Yes, but not in Workfront. The complexity of the transformation you need is beyond Workfront's built-in tools and can only be done via an ETL process using Fusion or other application via API. If you don't have easy access to Fusion or similar ETL tool to do this, I suggest reaching out to @Doug_Den...

Yes, this is a project filter and can be used when viewing any list of projects, whether in the Projects landing page or applied when creating a project report. The logic of the "Projects I'm On" button can't be changed, but you can select a default filter to be applied in Layout Templates. 

You want an EXISTS filter that basically says "show me open projects with work assigned to me, and my assigned work is not yet complete."There's a few approaches to that, but this is where we landed: EXISTS:a:$$EXISTSMOD=EXISTS EXISTS:a:$$OBJCODE=OPTASK EXISTS:a:actualCompletionDate_Mod=isnull EXIST...

Good news, @NickVa1 I SWEAR that I tried this before and it didn't work, but I saw it working in another environment and tried again with a fresh mind. Caveat is that you can't do this with a calculated view. But, you can do it if you add a calculated field to your project form. On your project cust...

Hi Chris,  This should decode a semicolon inside of a function:  {{decodeURL("%3B")}}      

It's not possible at this time. There is an active Idea submission to enable this feature, which you can find here:https://experienceleaguecommunities.adobe.com/t5/workfront-ideas/mailto-link-option-in-custom-forms/idi-p/522335I encourage everyone to vote for this, as it should be very simple for Ad...

Hi Jill. I believe this is the filter you are asking for: EXISTS:a:$$EXISTSMOD=NOTEXISTS EXISTS:a:$$OBJCODE=PRED EXISTS:a:isCP=true EXISTS:a:successorID=FIELD:ID

I suggest reviewing and comparing your status keys (PLN/CUR/CPL for projects, NEW/INP/CLS for issues). When tying a converted project status to it's originating issue status, the system first looks for an identical status key. If it finds an issue status key that matches the project status key, that...

Hi Mollie, 1. Parameter Group refers to Custom Form Sections, so that's unrelated to your current challenge. 2. Display Order refers to the order in which the Parameter Options are listed. 1 is first, 2 is second, etc. To my knowledge there is no API endpoint or syntax that will alphabetize the Para...