Thanks Doug! Unfortunately this isn't working either, still getting N/A for all the projects using Request Type.I never learned about ELSE statements properly but looking at the number of single and double quotes in your statement it feels unbalanced but I'm not 100% sure.
Yes the field is on both forms.Good eye! Case does matter I was typing quickly when I wrote the options, the case in the calc is the correct version with NEW and PROMO
I have two very similar custom fields that I am trying to report on using one calculated field, so I can report to leadership with all projects represented. I essentially need all of the options to funnel into two categories. The calculated field I created works perfectly for the first field (Packag...
I'm not sure how long you've been using Workfront @Aya Elsoukkary‚ , but you could also use that legacy data to calculate the average actual duration of the tasks and use that to keep your templates up to date for scheduling.
Same as Kevin,I would rather not create all new fields for my existing paragraph fields because that means I also have to find and edit the reports as well, not sure if it's worth the backend time.
Hey Mollie there is a similar thread that I think might help you.https://one.workfront.com/s/question/0D50z00006YMghc/need-help-with-a-view-field-trying-to-pull-specific-role-id-out-of-a-project-users-and-display-in-project-report-where-have-i-gone-wrong-ive-tried-a-few-variations-of-below
Sounds like you need to make one tweak to the code Jason provided, but I don't think the ID you're looking for exists. Ideally it would be instead of matching the assigned To ID to user ID you need to match user ID with assignments user ID.Could you do an assignment report instead of a task report s...
Similar to what Chuck suggested instead of making another team and having that list get astronomical I've chosen to create unique job roles just for sharing purposes and sharing access through that. I find it easiest to maintain.As far as a report to see programs shared with them, a user can only se...