Hi @TammyCa1 You could run task report or an assignment report - if those tasks can have multiple users, you likely want the assignment report. You can then group by user. As a filter you compare actual vs planned completion date: Task reportactualCompletionDate=FIELD:plannedCompletionDate
actualCom...
Hi @skyehansen Per APIexplorer there is a linking object "ProjectUserRole" (PTEAM) that has projectID and roleID attributes, but I'm failing to make an EXISTS filter work - what am I doing wrong?EXISTS:b:$$EXISTSMOD=NOTEXISTS
EXISTS:b:$$OBJCODE=PTEAM
EXISTS:b:projectID=FIELD:ID
EXISTS:b:roleID=64d51...
Hi @skyehansen "roles" is a collection on the project and is an array of roleIDs found on the project tasks.Per documentation "in" applies to arrays, so "notin" should, in my mind, mean "the collection of role IDs does not include ..."
Hi @JHulet what's the text mode you're using for "Predecessor project percent complete"? In general - the number of hops might be an issue with something like {predecessor}.{project}.{owner}.{name} because you want to display the name not just ownerID (a property on the project)You could try setting...
Hi @DestPr As with your last question I can't tell because I don't see the module configuration nor the flow of the modules. If you repeatedly get this same error please provide more info so we can troubleshoot.
Hi @MichaelSMN I can confirm what you describe. If e.g. ONLY "Email Role" is on the project the filter works. If there are multiple roles it doesn't.I tried cinotcontains (string match) as well as cinotin (array match) I've not seen "in" or "notin" work on the API - I think this is a bug . Did you ...
Hi @MattEl5 I haven't tried this but I doubt this will work: The style configuration operates on the object of the row - in your case, the PROJ. What you're doing in that cell is iterating over the project tasks (very low performing at scale) and printing out one specific task. That task's propertie...
Hi @OmahaOmaha I like Skye's suggestion of starting with the =100. As she pointed out, if you're never reaching the third condition because if the number is greater than 50, it ends with the second condition. Funnily your condition makes it so that if the completion score is 50 - the calculation sho...
Hello @DestPr When I try to add for 3 suffix, 3 task are getting created. But when i add a new suffix instead of creating one/new task with the new suffix, the tasks are getting duplicated its taking earlier 3 suffix and also taking the new suffix. .How/where are you adding the new suffix? From you...