Expand my Community achievements bar.

Richard_Le_
Richard_Le_
Offline
Type
  • All
  • Questions
  • Discussions
  • Ideas
  • Blogs
Filter by user contributions
  • Hi,   No, i'm afraid that this isn't possible. Tasks are classed as a collection on the project object (since a project can have multiple tasks) and it's not possible to pull the values from every task into a single field.   If the desired outcome is to pass all of the task statuses on a given proje...

    Type

    Questions

    Views

    45

    Likes

    0

    Replies

    1
  • Hi,   It's possible to display all tasks with a specific custom form attached in a project report, however not as clickable hyperlinks. Tasks are classed as a collection in a project report (since a project can have multiple tasks) and to my knowledge, you can't output a clickable link from a collec...

    Type

    Questions

    Views

    37

    Likes

    0

    Replies

    1
  • Hi,   Give the following text mode a try:   descriptionkey=durationMinutes durationunitfield=durationUnit.value linkedname=direct listsort=intAsInt(durationMinutes) namekey=duration querysort=durationMinutes styledef.comparison.leftmethod=intAsInt(durationMinutes) styledef.comparison.operator=gt sty...

    Type

    Questions

    Views

    70

    Likes

    2

    Replies

    0
  • Hi,   Try using the following text mode filter on a Journal Entry Report:   entryDate=FIELD:project:actualStartDateentryDate_Mod=gt   This text mode should filter to any Journal Entries where the entry date is greater than the Project actual start date.   Best Regards, Rich.

    Type

    Questions

    Views

    65

    Like

    1

    Replies

    1
  • Hi,   I would have a go at creating a report on the Note object in Workfront. You can read more on this here.   You should be able to filter to notes (updates) where a specific team was tagged, as well as pull in high level information about the task or project the note was added to.   Best Regards,...

    Type

    Questions

    Views

    99

    Likes

    0

    Replies

    0
  • Hi   That code is correct and works in my instance.   Is the custom field you have setup a single line or paragraph text field? If you are using a formatted text field to store the URL you will likely find that this wont work.   Other things to check are: Is the URL definitley correctAre there any s...

    Type

    Questions

    Views

    49

    Likes

    0

    Replies

    0
  • Hi,   I don't believe this is possible whilst you are using a calculated column in your report view. Calculated columns calculate data in real time and they only exist in the view itself, the calculations are not stored anywhere for Workfront to be able to aggregate into an average or sum.   What I ...

    Type

    Questions

    Views

    49

    Like

    1

    Replies

    0
  • Hey @Madalyn_Destafney,   Sure thing, this following text mode should do it. This will only return proof approvals where the overall decision is still pending on projects where DE:Region - DX Campaign Ops = "Americas"   EXISTS:1:$$EXISTSMOD=EXISTSEXISTS:1:$$OBJCODE=DOCU EXISTS:1:versions:ID=FIELD:do...

    Type

    Questions

    Views

    56

    Likes

    0

    Replies

    1
  • Hi Emma,   You could try creating a task report that has a primary grouping of Milestone>>Name and a secondary grouping of Parent>>Name.    This should display all tasks under each milestone and workstream in a similar way as you depict on the screen shot. You wont get the same task indentation as w...

    Type

    Questions

    Views

    223

    Likes

    0

    Replies

    1
  • Hi Matt,   Are you trying to filter your hours report based on a value in the company custom form? Or are you trying to pull in values from a company custom form into the report? The way I read your post it's the latter and you won't need an EXISTS statement as these are purely for filtering.   To p...

    Type

    Questions

    Views

    184

    Likes

    0

    Replies

    1
Top badges earned by Richard_Le_
Customize the badges you want to showcase on your profile