I have a task report that has a column for a custom field that we attach to tasks.
We also have a project report that is used by the team and I need to add a column on that report that displays these notes.
I'm striking out with every combination I try. Any ideas?
Topics help categorize Community content and increase your ability to discover relevant content.
I tried several things as well with no luck. Could it be that you can't report on this because 1 project could have many different tasks and all of those tasks could have different information that's all trying to relay into one cell in your report?
Hi - because you have a many to one relationship with projects and tasks, you have to do a collection in your project report. Here is the info on Workfront One for collections: https://one.workfront.com/s/document-item?bundleId=the-new-workfront-experience&topicId=Content%2FRe...
Based on what you have, I'm thinking your code would be the below.
Try that out. :)
Hmm... try this then with the CONCAT
Yay! that worked. I'm going to create and "Ask Anthony" group lol.
Thankyou for saving me once again!
LOL! Glad that work! As long as you have the Text Mode Reporting tag on your question, I'll see it. ;)