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

MMcAnelly
MMcAnelly
Online

Badges

Badges
17

Accepted Solutions

Accepted Solutions
0

Likes Received

Likes Received
20

Posts

Posts
43

Discussions

Discussions
7

Questions

Questions
35

Ideas

Ideas
2

Blog Posts

Blog Posts
3
Top badges earned by MMcAnelly
Customize the badges you want to showcase on your profile
Pull in the home group name of the person who originally submitted the request into a view - Workfront 11-11-2021
Hi, I'm trying to figure out the text mode that I would use in a view to pull in the home group of the person who originally submitted a request. When I select Entered By, Home Group the field is blank. valuefield=enteredBy:homeGroupNamequerysort=enteredBy:homeGroupNamevalueformat=HTMLdisplayname=linkedname=enteredBynamekey=view.relatedcolumnnamekeyargkey.0=enteredBynamekeyargkey.1=homeGroupName I appreciate any help. Thanks,Michelle

Views

8

Likes

0

Replies

2
Re: How to change format of entry date in calculated field - Workfront 04-11-2021
Thank you again. I really appreciate your expertise! take care.

Views

9

Likes

0

Replies

0
How to change format of entry date in calculated field - Workfront 04-11-2021
Hello, I'm working on creating a custom project code that uses the entry date as part of it. I got this calculation to work CONCAT((Entry Date),"-",Reference Number,"-",Queue Topic code) but the formatting of the date came in with this format 11/2/21 and I need it to be just numbers without the back slashes and read 11221 or even better 110221. Does anyone know of a way to do this? The output currently looks like this: 11/2/21-123456-CC but I want 110221-123456-CC I appreciate any help! Thanks,M...

Views

9

Likes

0

Replies

4
Re: How to build a calculated field on a custom form to pull in the year + Workfront project ID + queue topic - Workfront 03-11-2021
Thanks Skye. This is very helpful. I'm struggling a little with the correct calculation to pull that 2-digit code from the right of the queue topic name. Is this close? RIGHT({queueTopic},Queue topic name",2). I really appreciate your help on this! Michelle

Views

10

Likes

0

Replies

1
How to build a calculated field on a custom form to pull in the year + Workfront project ID + queue topic - Workfront 02-11-2021
Hello, I'm trying to create a custom project code that includes the year + Workfront project ID + queue topic from the request queue the original request came from. So, right now I have CONCAT(RIGHT(YEAR(Entry Date),2),"-",Reference Number) in a calculated field on a project report to pull in the first two components. How do I get the queue topic from the originating request queue to append to the end of that? So, we'd have 21-123456-queue topic And, then once the queue topic is identified assig...

Views

10

Likes

0

Replies

3
Re: How to create custom calculated job number field? - Workfront 02-11-2021
Thanks, Monique!

Views

21

Likes

0

Replies

0
Re: How To Capture Queue Topic Of The Request On The Project's Custom Form - Workfront 01-11-2021
Hi, Anthony I came across this post and I think it's getting me closer to what I'm trying to do but still need help. I'm trying to create a custom project code that includes the year + Workfront project ID + queue topic from the request queue the original request came from. So, right now I have CONCAT(RIGHT(YEAR(Entry Date),2),"-",Reference Number) in a calculated field on a project report to pull in the first two components. How do I get the queue topic from the originating request queue to app...

Views

19

Likes

0

Replies

0
Re: How to create custom calculated job number field? - Workfront 29-10-2021
Hi, Monique I'm trying to build a custom project number and came across this posting. I'm curious, is your Project Team Code tied to a different custom field you created or something created by the system? Can you please let me know? Thanks,Michelle

Views

21

Likes

0

Replies

0
Ability to filter on week days using date based wildcards - Workfront 05-10-2021
Would like the ability to filter on week days only when using the date based wildcards in reports. Currently, as a default, they only pull in calendar days so if you have a filter where you only go back 2 days and you run the report on Monday, you won't see any data.

Views

4

Likes

2

Replies

0