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

SarahNau
SarahNau
Online

Badges

Badges
22

Accepted Solutions

Accepted Solutions
9

Likes Received

Likes Received
13

Posts

Posts
146

Discussions

Discussions
13

Questions

Questions
133

Ideas

Ideas
1

Blog Posts

Blog Posts
0
Top badges earned by SarahNau
Customize the badges you want to showcase on your profile
Re: Tasks Shown in Project Report - Workfront 31-07-2018
Hey Matt, I would try this: displayname=Submit for PRC or Regulatory listdelimiter= listmethod=nested(tasks).lists textmode=true type=iterate valueexpression=IF(ISBLANK({actualCompletionDate}),IF({numberOfChildren}=0,IF(CONTAINS(" Submit for PRC ",{name}),CONCAT({plannedCompletionDate}," - ",{name}),IF(CONTAINS(" Submit for Regulatory ",{name}),CONCAT({plannedCompletionDate}," - ",{name}))))) valueformat=HTML Good luck! Sarah Nau Dominium

Views

17

Likes

0

Replies

0
Re: Export Custom Form - Workfront 05-07-2018
Wow - this is great - I spent about 2 hours the other day making an Excel spreadsheet of one of our largest custom forms. Glad to know that this exists so I don't have to go through that again! Thank you! Sarah Nau Dominium Inc.

Views

51

Likes

0

Replies

0
Re: Calculated Expression collection question - Workfront 21-06-2018
Morning Cameron, I would try this: displayname=Draft Assignee(s) listdelimiter= listmethod=nested(tasks).lists textmode=true type=iterate valueexpression=IF(CONTAINS("Draft",{name}),{assignedTo}.{name}) valueformat=HTML Note that "Draft" is case sensitive! Good Luck! Sarah Nau Dominium Inc.

Views

8

Likes

0

Replies

0
Re: Reporting on Custom Form Usage - Workfront 20-06-2018
Good Morning, I would try using the following as a column on a report for each object name: displayname= linkedname=direct namekey=category.name tile.name=component.objectcategories valuefield=objectcategoriesNamesString valueformat=HTML viewalias=category.name From there, you can export the data to Excel, use the remove duplicates option to see all of the forms that you are using for each object. You may also need to use the Text to Columns to separate out multiple custom forms that are attache...

Views

20

Likes

0

Replies

0
Re: Custom Field ID to Name in Project Report - Workfront 19-06-2018
Hi Yannick, You can pull task information on a project report by using collections in reports. There was a great presentation done at LEAP on this and I have attached the deck. Good luck! Sarah Nau Dominium

Views

69

Likes

0

Replies

0
Re: Programs with No Projects Report - Workfront 20-06-2017
I actually have a ticket in on reporting on a custom field change date - if I get back something that works I will share with you!

Views

38

Likes

0

Replies

0
Re: Display report with groups collapsed - Workfront 23-05-2017
I would like this as well - don't need things clickable but want the summary tab to display with the same sort as the report - looks like it defaults to alphabetical. Anyone know how to change this?

Views

41

Likes

0

Replies

0
E-Mail Link in Report - Workfront 20-04-2017
Hello - I am attempting to create a report that has a column with an e-mail address (input through a custom form) - but make it clickable. I got a URL to work, but not e-mail addresses. Any ideas? Thanks! Text Mode for URL Link (LP or Agency E Mail is my custom field) - tried adding mailto: before the e-mail address and that did not work either description=Email link.isnewwindow=true link.url=customDataLabelsAsString(LP or Agency E Mail) linkedname=direct listsort=customDataLabelsAsString(LP or ...

Views

7

Likes

0

Replies

0
Re: Using Workfront for event management? - Workfront 17-02-2017
Good Morning Sherry, We are an apartment management and development company that is growing fast. We use request queues for all grand opening and groundbreaking event requests. We use the queue to get all of the necessary information in different custom forms for each type of event. The request goes to our marketing department as a group. They all get a notification and have a dashboard to view all requesting and works in progress. Each request (issue) is turned into a project from templates for...

Views

17

Likes

0

Replies

0
Display task status in column view of project report - Workfront 10-02-2017
Hello, I am looking to create a project-level report that displays the status of multiple tasks within each project. I want it to look like this: Project Name - Task 1 - Task 2 - Task 3 (Columns) Project 1 - Complete - Complete - In Progress Project 2 - Complete - In Progress - In Progress Project 3 - In Progress - New - New Anyone know some coding that can pull task status at the project level? 'Task 1' would have the exact same name in each project. Thanks!!

Views

15

Likes

0

Replies

7