AdaptiveWork

It would be useful to have a button to export capacity planning data to an excel spreadsheet as some users requested to capture for reporting purpose

Is it possible to tell Slide Publisher how to sort/order the results of a repeating slide?

Is there a way that we can give our executive leaders access to capacity planning without making them resource managers in the system?

Hi Everyone,Hoping this is an easy answer.  Is there a way to utilize a custom action to change the view of a project?  I have a couple use cases where I need to have a user change from a project details ‘overview’ view to a gantt chart view and would like to have that fire off via custom action rather than have the user manipulate the ‘project details’ view manually.I am leveraging the Dynamic Layouts to manipulate the project details, but need to move to a gantt view. Thank you!  

I have been trying to generate a document publisher report on a Project that creates a related table from the Targets module. Every approach I’ve tried has caused the file to be corrupted with the error “Word found unreadable content in test.docx. Do you want to recover the contents of this document? Approaches triedTargets via AssociatedItem (the obvious answer) Targets with my own reverse reference Targets via ContributingWorkItems (not sure if this is a real capability) Contributions AssociatedItem TargetHierarchyLink with my own reverse referenceI noticed the doc publisher macro template doesn’t include any reference to Targets or Objectives, so I’m wondering if perhaps it’s just not supported?I did verify that Slide Publisher can pull the same data out, so definitely just a problem specific to makin word docs.Interested to hear from anyone who has managed to generate a related table of targets in document publisher, and what sort of comment syntax you’re using :)

Custom Field to calculate what % of Financials Fields  I have a custom field that captures the Total Authorised committed (Sum of Actuals YTD + ERP Commitments) currency field and Low Estimated Budget (sum of 2025 & 2026 budget & 2027 budget) currency field.I want to calculate the % of (Total Authorised committed $ / Low Estimated Budget) *100 Error: Loop found in field 'C_TotalAuthorisedCommitted' 

Looking to create a Custom Action that is only available on projects that are associated to a particular Portfolio.  I was encouraged to attempt to reference portfolios by the ID field, rather than by name or use of a toggle, but a custom field(toggle) has been the only way I’ve been successful thus far.  I’ve tried using multiple syntax variations of the GetLink function but that doesn’t seem to support a Portfolio Project Link.  e.g. GetLink($ProjectPortfolioLink,'PF-101',CurrentObject()) » Error: Invalid field name: 'ProjectPortfolioLink'.   I’ve tried other Work Item-to-Work Item links without success.  Is a custom field on the project the way to go?  Should Reporting and KPIs be driven off of the toggle as well?

Hello, We have a case where some of our resources have multiple skills. How can we specify which skill is potentially being utilised on a Project when a resource is assigned?For example a PM adds Resource 1 who has two skills. On this particular project they are only utilising one skill. The PM adds Task Assignment over the required period etc. In reports, we can’t specify which skill is being utilised on the ProjectDoes anyone have any ideas to manage this or potentially another solution potentially through a custom field? e.g. a picklist in the Resource assignment panels when the PM can select which of the users skill is being utilised etc. Many Thanks

Hi Team, is it possible to create workflow/custom action when a personal timeoff is added in Clarizen by a user, the manager gets a notification?

Hello everyone 👋 We are setting up our instance of AdaptiveWork and can see some great functionality with individual calendars using the exception types to put in their leave etc. However, although we have been able to add our own categories, we have not been able to work out how to delete the other items in the pick list. We are finding that the categories are adding confusion that are already in e.g. PTO and vacation for us would be the same definition.  We have changed our categories to have numbers at the beginning so that they go to the top but is there a way to delete the other options?

What’s the best approach, if any, to set an effective date for a new capacity so that future tasks reflect the updated capacity, while past assignments and capacity remain unchanged? We pull capacity reports and are transitioning a full-time employee to part-time. When we update the capacity in the and dates in their calendar, it ends up affecting the capacity for past dates as well.

I need to distinguish in my projects different non-labor expenses categories. This distinction shall be done per location. Example : “non-labor resources A” for location A, and “non-labor resources A” for location B.One of the solution would be to differentiate in the non-labor resources list them (ie “non-labor resources A location A” and a second one “non-labor resources A location B”). Doing so, the list of choices proposed to the project manager will explode (in my case more than 60), which will not be that easy for the userIve seen in the last AW documentation (see below) that there is an example with “vendor” column, whcih can be edited. Does it mean that i can have (to stay in the example below) multiple times “Telephone” with different vendor? Or there is still the limitation that the non labor resources can be used only once ?Any idea how i can solve my issue? 

When adding a staff member to task that spans the end of month - and the historic month is fiscally closed - it still seems to add the allocation - changing the past, supposedly locked, financial forecast. Have I got how allocation works incorrect? Any tips?

Hi All!I am brand new to AdaptiveWork / Clarizen and trying to grasp how something like this would be built, and/or how easy it would be.Use Case:  We have about 20 fields with associated score values, and we wish to use the score values in a formula to calculate another field.Approach:  Rather than hardcoding the score values within a formula, I created a Custom Object with the possible field values and the associated scores. This seems easier to maintain than a ton of code. Also, I’m trying to learn how the product works so it’s also just for my curiousity.Question:  How hard is it to create Business Rule that looks at a field value, and then does a lookup to a record in a Custom Object and retrieve the Score value? I was able to get as far as retrieving a value from the Custom Object by using the GetObjectByID function, but only when I hardcoded in the ID.  I am looking to do a join on the Name field rather than ID between my request field and the possible entries of the Custom Obje

Hello team,I want to pick data source " date visite sur site APS" and apply to target ("date de début" from "date de visite sur site APS") this field To explain the situation to you: I have a field in a table that is manually filled. I want the field in another table, which corresponds to the intersection of two values, to be updated as soon as the first field is modified.Could you please assist me about this workflow rule please ?

New to AdaptiveWork here and don’t know if we are missing something.How do we @mention all Project members (including Resources with Team Member license) in a discussion post started on the Project and from a discussion post started on any Task in the Project.We DO NOT want to create a discussion group for every single project.We have some ideas for custom actions or workflow rules but want to make sure we aren’t missing an easier option before creating workarounds.Any help would be greatly appreciated, we are going live in the next week and this is something that is required.Thank you so much!

Is it possible to return the name of a project’s related customer when querying the project via the API?  I believe the relationship is between project, customerlink and customer.  However, I can’t see how to relate customerlink to project as I get the following error:Query:https://api.clarizen.com/v2.0/services/data/query?q=SELECT name, sysid, customerlink.customer.name FROM project WHERE id = '<PROJECT ID HERE>'And got this result:    "errorCode": "InvalidField",    "message": "Entity 'Project' does not contain the field 'customerlink'", When I try to query the customerlink with the same project ID using:SELECT customer.name, entity.name FROM customerlink WHERE entity = '<PROJECT ID HERE>'Then I get the name from the customer table and the name from the project table.  I just don’t seem to be able to get the customer name by querying the project tableI’ve had this problem with other entities, specifically when trying to link tasks with files/attachments.If anyone has any

Is it possible to set up a dependency so that a PM cannot request resources until a project task or milestone is marked complete? 

Can anyone please provide an example of a Custom Class Name to format a font (size, etc.) in a grid view ?

Is there any way to upload pictures or files from my local machine via the API? Looking into using Sharepoint’s API as a workaround assuming Adaptivework’s API doesn’t have this capability. But wanted to see if this is a functionality allowed by Adaptivework’s API or if there are any other good workarounds in the community Thanks!

I have added few persons as reviewers by default when a new project is created. Project manager can add more reviewers later on also. But can a reviewer add another reviewer to same project? Is this functionality directly available or do we need to think to provide editor access to that particular reviewer to achieve this?

Hello everyone, I’m looking for advice and insights on how you’re utilizing the Resource Planning module to get a forward looking view of workload. Specifically, I’m interested in understanding how you’re managing and forecasting resource demands and capacity.Some questions I have: How do you use the resource planning module to anticipate future workload?  Are you creating dummy projects linked to demand to simulate upcoming work? If so, how effective has this been?  What strategies or practices have you found most useful for aligning resource availability with future project needs?  I’d greatle appreciate any examples, tips, or best practices that you can share. Looking forward to hearing how others are making the most of the tool. Thanks in advance for your insights!Best regards,Maca

Hi Planview Community,I hope someone can help us with the following issue in AdaptiveWork:We have a project with some activities where the resource assigned by the project manager occasionally requires support from another resource. We need the main resource (assigned by the project manager) to be able to modify only two fields within the activity: “% Percent Complete” and “Resources” (adding and removing resources). Is there any way to make this strictly possible for these two fields without granting permissions for the entire project or the projects module to the main resource?Thanks for your support.Best regards.Oscar SuarezPM

Hi,We are using Custom Object inside our projects. We can add new person as a reviewer to the projects using dataloader which gives them permission to view the project data. But is there any way to provide permissions to custom object using dataloader directly? We have created a custom action for now but there is a limitation that it will take 50 rows at a time and we have to click multiple times to provide permissions.If  this is possible then please share a sample for dataloader file. I checked the fields but not sure how to provide viewer role.