Thank you for your response! That was my previous solution, but the problem is the projects repeat in the report due to having multiple rounds. So a project with 7 rounds will show up in all sections. Is there a way to remove the repeats? For a example a project with 7 rounds will ONLY appear in the...

Hello! Previously I'd been tasked to group parent names by R1, R2, R3, etc. Now they've moved the goal post and want me to edit the report to count how many projects go up to R1, up to R2, up to R3, etc.  I've started the expression: IF((CONTAINS({parent}.{name},"R1"),(NOTCONTAINS({parent}.{name},"R...

I'm creating a task duration report for a single job role (along with the marketing round report in another post), and I'm close to finishing it. I managed to convert the task duration to days but for some reason the same edit won't work in project duration. I've tried calculated custom fields and e...

I tried making the edit, and I got a null object again. I even tried adding the expression in a custom form and got this response: "This is an invalid custom expression, please try again." I must be doing something wrong. I swear editing in text mode hates me, and the feeling is mutual!  

Hello! I've been tasked to create a parent task report. It needs to be grouped by rounds, but a lot of the parent tasks have naming conventions beyond just a simple R1, R2. R3, etc. So I tried to go to text mode, but the result keep coming up either No Value or Null_Object. One of my biggest issues ...