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...

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

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 fi...

Thanks, Monique!

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 CON...

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

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.