Quick Tip: Add a column to your task report to show the Working On status

When one or more person is assigned to a task, you may want to know who has said that they're working on that task, who is done with their part, etc.

Create a Task Report and add a column with the following text mode code to surface that information and provide this critical information for each assignee:

displayname=Assignments and Status

listdelimiter=<br>

listmethod=nested(assignments).lists

namekey=group.plural

textmode=true

type=iterate

valueexpression=CONCAT({assignedTo}.{name}," - ",IF({status}="AA","Requested",IF({status}="AD","Working","Done")))

valueformat=HTML

width=150

"Like" this post if you find it helpful!👍

To find all previous Quick Tips, go here and view the Discussions tab.