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

NicholeVargas
NicholeVargas
Online

Badges

Badges
35

Accepted Solutions

Accepted Solutions
12

Likes Received

Likes Received
131

Posts

Posts
235

Discussions

Discussions
8

Questions

Questions
227

Ideas

Ideas
4

Blog Posts

Blog Posts
0
Top badges earned by NicholeVargas
Customize the badges you want to showcase on your profile
Re: How do you filter users that are not in a specific team? - Workfront 06-04-2022
Josh - it can be done through an EXISTS filter on a User Report. If you switch to text mode filters, paste the following and swap out ID HERE with the ID of the specific team you want to filter for, that should work. This will pull in a list of all users missing from that specific team, regardless of whether or not it is listed as their Home Team or under Other Teams. EXISTS:A:$$EXISTSMOD=NOTEXISTSEXISTS:A:$$OBJCODE=TEAMMBEXISTS:A:teamID=ID HEREEXISTS:A:userID=FIELD:ID If that isn't exactly what...

Views

8

Likes

0

Replies

0
Re: Can you limit a report to only show multiple rows of a particular grouping? - Workfront 06-04-2022
Ryan - I'm not sure if you've tried this already, but applying a chart may help (if it doesn't error out because of too many results). There's not currently a way to sort a grouping based on the number of results, however, a chart may help you easily identify which projects are sharing the same compliance code because those columns/bar/pie slices would be larger than the others. I'm not sure if anyone else has other suggestions, but this may be a good starting point!

Views

6

Likes

0

Replies

0
Re: addMonths in calculated field - Workfront 06-04-2022
Amanda - just to help clarify, are "Closing Date" and "Calculated" two different custom form fields in your system?And what format are they? I imagine "Closing Date" is a date field, but what type of field is Calculated? If you just wanted to calculate 18 months from the Closing Date field, you would use ADDMONTHS(Closing Date,18) Let me know!

Views

36

Likes

0

Replies

4
Re: How to find all users who do not belong to a specific group? - Workfront 06-04-2022
Jill, This is possible using an EXISTS filter within a User Report. You'll want to switch to text mode and replace ID HERE with the ID of the specific group. This will pull in a list of all active users who do not have that group listed as either their Home Team or under Other Teams. EXISTS:A:$$EXISTSMOD=NOTEXISTSEXISTS:A:$$OBJCODE=USRGPSEXISTS:A:groupID=ID HEREEXISTS:A:userID=FIELD:IDisActive=trueisActive_Mod=eq If this wasn't exactly what you were looking for, or have additional questions, let...

Views

9

Likes

0

Replies

1
Re: Is there a way to restrict assigned tasks from appearing on a user's timesheet? - Workfront 04-04-2022
Robert - If an assigned task or issue meets the criteria selected under Setup > Timesheets & Hour > Preferences > Pre-Populate Timesheets with, then it will appear on a user's timesheet and cannot be removed unless the user is un-assigned. Also, remember that if a task or issue has been pinned to the timesheet, it will stay there until un-pinned. If you have any questions, let me know!

Views

13

Likes

0

Replies

0
WANT BEST PRACTICES AND SAMPLE REPORTS FOR SYSTEM CLEANUP? - Workfront 11-03-2022
Join the Workfront Customer Success team on Tuesday, March 22 at 9:30 am MT for a 1-hour small group workshop on how to best leverage reporting for system cleanup, including a hands-on exercise where we will build a custom form usage report together! This session will be interactive, so bring your questions and be prepared to come off mute. Register for the workshop through Workfront One > Events > Workshops or by clicking here.

Views

10

Like

1

Replies

0
Re: Is there a way to calculate the actual duration for an issue? - Workfront 03-09-2021
@Ryan Kirk‚ This should work! I added an IF statement so that it says if the planned completion date is less than today, show as a negative, otherwise, show as a positive: displayname=Weekdays to Planned Completiontextmode=truevalueexpression=IF($$TODAY>{plannedCompletionDate},CONCAT("-",ROUND(DIV(WORKMINUTESDIFF($$TODAYb,{plannedCompletionDate}),480),0), " Days"),CONCAT(ROUND(DIV(WORKMINUTESDIFF($$TODAYb,{plannedCompletionDate}),480),0), " Days"))valueformat=HTML If you have any questions, let ...

Views

29

Likes

0

Replies

0
Re: How would I go about grouping task report results by the pending task approval stage? - Workfront 04-08-2021
Stephanie, You can use the following text mode to group the results by Current Approval Stage: group.0.displayname=Current Stagegroup.0.valuefield=currentApprovalStep:namegroup.0.valueformat=HTMLtextmode=true You should be able to apply a chart that will organize the results by the outstanding stage name. If you have any questions, let me know!

Views

9

Like

1

Replies

1
Backlog Report Grouping - Workfront 30-07-2021
Allow the option to have "Backlog" as part of the Status grouping when reporting on Agile tasks for Kanban teams. Currently, only active statuses (those with an iteration ID - New, In Progress, Complete, etc.) display.

Views

4

Likes

2

Replies

0
Report on Average Duration by Task - Workfront 17-05-2021
Currently, duration can be only be averaged at the project level, so if you attempt to add a filter for a specific summary task or template task, the system does not generate a number. As a new version of reporting is likely coming out, can we considering adding this functionality in so that we can break down project timelines by summary tasks, at least, to understand how long specific tasks take, without having to leverage text mode.

Views

5

Likes

2

Replies

0