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

TealeMcCleaf
TealeMcCleaf
Online

Badges

Badges
27

Accepted Solutions

Accepted Solutions
16

Likes Received

Likes Received
108

Posts

Posts
154

Discussions

Discussions
16

Questions

Questions
138

Ideas

Ideas
14

Blog Posts

Blog Posts
0
Top badges earned by TealeMcCleaf
Customize the badges you want to showcase on your profile
Re: SQRT Function to Aggregate in Calculated Column? - Workfront 09-06-2021
Yes and No... When I changed the aggregation function to SQRT, it doesn't work but it does correctly give me the sum. Thanks for your help!

Views

21

Likes

0

Replies

0
Re: SQRT Function to Aggregate in Calculated Column? - Workfront 09-06-2021
Yes, exactly... so this is what I have aggregator.displayformat=customNumberAsStringaggregator.function=SUMaggregator.namekey=PERT Varianceaggregator.valueexpression=ROUND(SUM(SQRT({DE:PERT Variance}),2))aggregator.valueformat=HTMLdisplayname=Project Standard Deviationlinkedname=directnamekey=PERT Variancequerysort=DE:PERT Variancetextmode=truevalueexpression=ROUND(SUM(SQRT({DE:PERT Variance}),2))valueformat=HTML I get the SUM in the Grouping header but not the square root. Not sure why it won't...

Views

21

Like

1

Replies

2
Re: Is there a way to set the Status of a Project to Approved once the Approval process completes? - Workfront 08-06-2021
Hi John, The only way to make the project status change to Approved automatically is to use the Approved status as the trigger for your approval. If you are concerned that the user won't trigger the approval and instead just change the status, you can create a report that shows the approval path details. I use this to capture the approval workflow end to end. column.17.displayname=Project Approval Flow Detailscolumn.17.sharecol=truecolumn.17.textmode=truecolumn.17.usewidths=truecolumn.17.value=A...

Views

11

Likes

0

Replies

1
Re: Edit existing update - Workfront 08-06-2021
Hi Nick - You can delete comments on the updates tab if the "Never allow users to delete comments" is NOT checked in the Access Level settings under Set additional restrictions. We recently found a bug in our instance because the Delete option was not showing. I would contact support if you are experiencing the same. Hope this helps, Teale

Views

25

Like

1

Replies

0
SQRT Function to Aggregate in Calculated Column? - Workfront 08-06-2021
I'm recreating a project methodology in Workfront using a series of calculated fields to identify 6 Sigma variances for the tasks on the projects critical path. The final step is to calculate the Standard Deviation as the square root of the sum of the variances. Everything works until I add SQRT as the aggregator function in the column. Does anyone know if this is possible? Thanks - Teale

Views

21

Likes

0

Replies

5
Re: Project Approval Process Problem - Workfront 08-06-2021
Hi Samantha, Unfortunately, someone has to actually change the project status to something other then "On Hold" and the change it back to "On Hold- Pending Approval" in order for Path 2 to trigger because the system doesn't allow for you to set the trigger to a " - Pending Approval" status. Sorry to be the bearer of bad news. Best - Teale

Views

30

Likes

0

Replies

4
Re: Modify Personal Time Off for Direct Reports - Workfront 08-06-2021
Hi Nick, The only way I can think of to accomplish this is by giving the Managers an access level that allows them to Edit the Users information. You could create a Group for the Managers team and make him a Group Admin with those permissions. Hope this helps, Teale

Views

8

Likes

0

Replies

0
Re: Is there a way to categorize Issues for reporting? - Workfront 03-06-2021
Hi John, If you're using Queue Topics, you can pull them directly into an Issue report by pulling the Queue Topic Name (queueTopic:name) into a field. You can then group by the field. Alternatively, if you could try the Request Type (Topic Type shown above) field if you have associated them distinctly with the types of request. Hope this helps, Teale

Views

19

Like

1

Replies

1
Re: Does anyone know if it is possible to customize a column to pull information from multiple fields into one column at the Project list view level? - Workfront 24-05-2021
Hi Laura - Yes, you can do that... Here's a great video that shows you how. Also, I'm happy to meet offline if you'd like to walk through it together. Best - Teale

Views

7

Like

1

Replies

1
Re: üî∫üî∫üî∫ Cooking up something amazing in your reports? Share your best report “recipe” with us today. üî∫üî∫üî∫ - Workfront 14-05-2021
This looks amazing Kyna! Love this and I look forward to seeing the cookbook when it's done.

Views

25

Likes

0

Replies

1