Level 5

Solved

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

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

Community Advisor

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.

Accepted solution

Community Advisor

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

Level 5

Hi Kellie,

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

Community Advisor

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.

Sign up