Hi all!I have a task report which pulls parent tasks with a certain name. The second column is the parent task name + a custom field called "Internal Design Comments" and it is working properly; the third column should be a list of child tasks alongside any "Internal Design Comments" at that task le...

Thank you Kellie!! This fixed it!The only other thing is I wanted the issue names hyperlinked to the issues, but for anyone who finds this thread in the future, it seems that's not possible currently.My final code is:column.10.displayname=Issues column.10.sharecol=true column.10.textmode=true column...

Hi all!Trying to add a list of all issues in a project, onto a project report. What I currently have is:displayname=Issues listdelimiter= listmethod=nested(opTask).lists type=iterate valueexpression=CONCAT("• ",{opTask}.{name}) valueformat=HTML and in the place of "opTask" I have also tried opTasks,...

Ohhh I see! Makes sense. I'll try this tonight and post an update — thank you!

Hi all! I'm working on a project report, and have added a column with the following text mode code:displayname=People listdelimiter=<div> listmethod=nested(projectUsers).lists type=iterate valueexpression=CONCAT("• ",{user}.{role}," — ",{user}.{name}) valueformat=HTMLI've used this basic setup in ot...

Is there a way to do this with full words rather than characters?

Hi @Daniel_Clarke! Yes, there's history of two people going from "Reviewer & Approver" to "Reviewer" — their decision in my report is "-". Another person was removed entirely and still is marked as "Pending".Ideally, the report would only pull people who currently have a Decision-maker role on the p...

Hi all!I just built a Proof Approvals report that lists every potential proof decision within a few specific programs (groupings are Approver Role > Approver Name > Document Version Decision). I noticed that under one approver's name, there was a pending approval for a proof he had been removed from...

When I try it this way, it gives me Link where the hyperlink text is just "link" instead of the URL. I wish it worked this way, much easier haha. Skye's answer below was the fix!Thank you so much for your quick replies, Kurt!!

YES! Thank you, Skye!! Final answer:displayname=URL link.url=URL valueexpression=IF(ISBLANK({URL}),"","Link") valueformat=HTML