It's difficult without seeing the result but LEN is a function that calculates string length. In Excel, you use the above to remove characters from a result. For example; Value = 45 Hotdogs Formula = VALUE(LEFT("# Hotdogs",LEN("# Hotdogs")-8)) --- "# Hotdogs" would be a cell value, for example B2 Re...

Hi Isabel, We tested the Workfront for JIRA integration and found it wasn't scalable for our purposes. The two main findings were: Integration is unidirectional; so only objects created in Workfront will populate JIRA. The integration is very difficult to implement and requires ongoing maintenanc...

Hi Jane, We usually create two projects. One that details the project in the form of a WBS, potentially higher level, with milestones etc and then a standalone project which acts as the product or project backlog. We could merge these and leverage parent tasks but it's cumbersome to maintain project...

Hi Frank, For incomplete tasks, we first discuss as a team why the scope was not delivered and then we split the task by adding a part 2, 3, 4 etc directly on the current iteration storyboard. We set the former as complete, if we delivered part of the scope, and leave the part 2 task in the new colu...

Hi Cathy, One solution would be to keep task 1, task 2 and project settings as they are but add an approval process on the 'code review' task (see Miranda's comment). This ensures all code reviews are completed and approved by the person responsible/accountable for that task. If User A accidentally ...

Hi M.L., Our projects also number in the thousands. We try our best to design a view and access framework, using wildcards and groups, to optimise the experience for our end-users - ideally, using custom dashboards in the place of the project tab, they only see the projects they work on or need acce...

Hi Erika, I am also able to replicate and it's an important use case for our business too - thank you for flagging! It looks like if an SME commits to work on a task it will always appear in their My Work list whether the project is in planning or in-flight status. I have tested a few status behavio...