Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

RichardLe1
RichardLe1
Online

Badges

Badges
26

Accepted Solutions

Accepted Solutions
67

Likes Received

Likes Received
465

Posts

Posts
218

Discussions

Discussions
0

Questions

Questions
218

Ideas

Ideas
0

Blog Posts

Blog Posts
0
Top badges earned by RichardLe1
Customize the badges you want to showcase on your profile
Re: Showing the Note entered by name on a report - Workfront 25-08-2022
That's strange, the code works perfectly in my instance. Are you using a task report?

Views

6

Likes

0

Replies

0
Re: Limits to Projects/Reports/Forms - Workfront 25-08-2022
Hey, I don't believe there is any limit to the number of forms or reports that you have in Workfront, however regular housekeeping and maintenance is certainly recommended as best practice! There was a recent webinar on this topic that you might find useful. Take a look at the recording here Best Regards, Rich.

Views

2

Likes

0

Replies

0
Re: Showing the Note entered by name on a report - Workfront 25-08-2022
Hi Mary, The textmode used is sound, but it looks like when it's been copied from an external source, some of the formatting / special characters have carried over + some additional lines of code which aren't needed and Workfront doesn't like it. Try the following code instead: displayname=last update namekey=latest update textmode=true valueexpression=IF(LEN({lastNote}.{noteText})>140,CONCAT(SUBSTR({lastNote}.{noteText},0,139),"…(open for more) — ",{lastNote}.{owner}.{name}," on ",{lastNote}.{e...

Views

8

Likes

0

Replies

2
Re: Pulling a Specific Job Role via Text Mode - Workfront 24-08-2022
You're very welcome, glad I could help.

Views

1

Likes

0

Replies

0
Re: Pulling a Specific Job Role via Text Mode - Workfront 24-08-2022
Try this instead: displayname=PM's On This Project listdelimiter= listmethod=nested(projectUsers).lists textmode=true type=iterate valueexpression=IF({user}.{roleID}="INSERT ROLE ID HERE",{user}.{name}) valueformat=HTML That should work.

Views

9

Like

1

Replies

2
Re: Pulling a Specific Job Role via Text Mode - Workfront 24-08-2022
Do these users have Creative Project Manager set as their primary role in the system, or are they secondary roles?

Views

13

Likes

0

Replies

4
Re: Assigning Bill Rate to a Task - Workfront 24-08-2022
Hi, Have you explored the 'Fixed Hourly' revenue type setting available at the task level. My understanding is that with this setting applied, you can dictate a specific billing rate for hours recorded on that task (that will supercede any rate set at the user, job role or project level).This article goes into some detail about the different settings. Best Regards, RIch.

Views

3

Likes

0

Replies

1
Re: Groups Report: list users? - Workfront 24-08-2022
Hi Laurence, Try the following text mode displayname=Group Members listmethod=nested(userGroups).lists listdelimiter= textmode=true type=iterate valueexpression=IF({user}.{isActive}="true",{user}.{name}) valueformat=HTML Note that the above will only return the username if their account in Wokfront is active. Hope this helps! Best Regards, Rich.

Views

7

Like

1

Replies

1
Re: Pulling a Specific Job Role via Text Mode - Workfront 24-08-2022
Hi, You will be able to achieve this with the following text mode: listdelimiter= valueexpression=IF(CONTAINS(“Creative Project Manager”,{user}.{role}.{name}),{user}.{name}) listmethod=nested(projectUsers).lists valueformat=HTML displayname=PM's On This Project textmode=true type=iterate Using the above code, Workfront will return any members of the project team (i.e., anyone assigned to tasks, the owner, or sponsor) who have Creative Project Manager as their primary role. Best Regards, Rich.

Views

20

Like

1

Replies

6
Re: Calculated field to track time spent (duration) in a Project Status - Workfront 23-08-2022
Hi Seth, A couple of ways you could achieve this: 1. Build a series of calculated fields that capture the date / timestamp of when a particular status was applied to the project. In the following text mode example, I have created a calculated field called 'Date Set To Current', the field will populate with the date/time that the project status was first changed to current IF({status}='CUR',IF(ISBLANK({DE:Date Set To Current}),$$NOW,{DE:Date Set To Current}),{DE:Date Set To Current}) You would ne...

Views

5

Likes

0

Replies

0