Counting The Number of Assignees On A Task [Textmode]

Hello,

I am trying to get a column in a Task report showing the amount of assignments/assignees on a task. Is this possible?

I tried this but only got 0 as a value.

displayname=Assignment Count
valueexpression=IF(ISBLANK({assignments}), 0, COUNT({assignments}))
valueformat=HTML

Thank you,
Eric

Best answer by KellieGardner

Hi Eric - you cannot "count" in Workfront. It's not a calculated data expression that's accepted. Overview of calculated data expressions | Adobe Workfront

KellieGardnerAccepted solution

New Participant

Hi Eric - you cannot "count" in Workfront. It's not a calculated data expression that's accepted. Overview of calculated data expressions | Adobe Workfront

New Participant

Hi Kellie,

Thanks for the info, is there another way you recommend going about displaying the number of assignments on a task?

New Participant

I haven't tried, but at least in principle something like this could work.

1. use assignmentsListString field as your reference, this is a string

2. use LEN to see how long it is, and this works with strings

3. items in this list are coma separated

4. Replace all commas with blank space LEN(REPLACE({YourField}, ",", ""))

5. Difference in length should be number of your assignments.

LEN({YourField}) - LEN(REPLACE({YourField}, ",", ""))

This is just theory, not sure if it works. I would plug in fusion to get the number for convenience.

New Participant

Same here.

assignments clearly is an array, so I tried to use ARRAYLENGTH but like you, just get zeroes.

I'd put in a ticket asking why this is not evaluating.

Sign up