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 ...