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

apentico
apentico
Online

Badges

Badges
10

Accepted Solutions

Accepted Solutions
3

Likes Received

Likes Received
8

Posts

Posts
12

Discussions

Discussions
2

Questions

Questions
10

Ideas

Ideas
2

Blog Posts

Blog Posts
0
Top badges earned by apentico
Customize the badges you want to showcase on your profile
Re: Adding external workers to production - Workfront 16-08-2022
We do the same for our users that do not have SSO.

Views

52

Likes

0

Replies

0
Re: Who have migrated to Adobe Admin Console? - Workfront 11-04-2022
I am also very concerned about this. I have struggled to get any information out of our account rep or from the support ticket that was sent over - this thread has actually been more informative. Our company also does not really utilize other Adobe products so this seems to be more of a headache than anything.

Views

131

Like

1

Replies

0
Re: Need help with a Calculated Field Expression - Workfront 21-03-2022
Hi Kundan. You can use the CONCAT function to combine the reference # and project name. Below I have the two separated by " - " but you can change that to what works for you in the valueexpression line. displayname=Reference + Namelinked.valuefield=namelinked.valueformat=HTMLnamekey=namequerysort=nametextmode=truevalueexpression=CONCAT({referenceNumber}," - ",{name})valueformat=HTML I am not sure if you still want to restrict to the first 10 characters as well. This option restricts to 10 charac...

Views

56

Likes

0

Replies

0
Re: Need help with a Calculated Field Expression - Workfront 15-03-2022
Hi Kundan. To get the first 10 characters, I would use the LEFT function. Using LEFT(Name,10) on a Project would give you the first 10 characters of the project name. Below is the text mode I used to create a column in a project report that would show the first 10 characters of the project name and then still link to the project. I bolded the part that does the link. displayname=Shortened Namelinked.valuefield=namelinked.valueformat=HTMLnamekey=namequerysort=nametextmode=truevalueexpression=LEFT...

Views

56

Like

1

Replies

0
Re: Need help with a Calculated Field Expression - Workfront 14-03-2022
Hi Sarah. You can use Replace to remove the spaces. The bolded section in the equation below is what I used on a project custom form that will replace spaces with an underscore. The equation would need to change a bit if you are adding the custom field to a different object or if you are just creating a calculated column in a report/view. CONCAT(Reference Number,REPLACE(Name," ","_")) The result for a Project A with a reference # of 123 would be: 123Project_A Hope this helps!

Views

56

Likes

2

Replies

7
Re: How to report when form is not attached to task? - Workfront 02-02-2022
Hi Catherine. If you are looking to see tasks that are missing a particular custom form, you can create a task report/filter and use Categories > ID and then Not Equal to "Form Name". Using the Categories (plural) will search all custom forms attached - rather than just the first. If you are wanting to see tasks without any custom forms attached, you can use Categories > ID Is Blank. Hope this helps!

Views

17

Like

1

Replies

1
Re: Is there a magical way to export the milestone report in excel? - Workfront 28-01-2022
Text mode can be tricky but once you get it right it can open up a lot of possibilities. If you want to send over your text, I would be happy to help. Good luck!

Views

16

Likes

0

Replies

0
Re: Is there a magical way to export the milestone report in excel? - Workfront 27-01-2022
I don't have the magical export option. But I have used text mode in project reports to create something similar that can be exported. This also helps if you need any additional information that is not captured in the milestone report. Below is an example of the text mode I have used (this would go into a column of your report). You would update the valueexpression line to match your scenario: milestone name, planned/actual/projected completion, etc. Then repeat for each milestone you need. Ther...

Views

16

Like

1

Replies

2
Re: How do I filter a Report to only show projects that include a particular Custom Form and in that report display the info from that Custom Form? - Workfront 30-08-2021
Hi Chris. Make sure you are using the plural version of Categories. This will look at all custom forms regardless of the order. If you use Project >> Category ID, it will only look at the first custom form.

Views

24

Like

1

Replies

0
Re: How do I filter a Report to only show projects that include a particular Custom Form and in that report display the info from that Custom Form? - Workfront 23-08-2021
In a project report, you can use the filter Categories >> ID. Then you can add in the name of the custom form you want to filter by. The 'Categories' object will look at all of the custom forms that are applied to the project. It's always a tricky one to remember that custom forms are known as categories. Hope that helps!

Views

24

Like

1

Replies

4