Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Help with Calc Field for Project Report


Level 6

Just checking out discussions for couple reports I am struggling with and see another post by @Randy Roberts‚ using same calc I use from @Doug Den Hoed‚

I'll just copy/paste first line- TY 😃

I have a column (in a project report) that lists the current task(s). Thanks to @Doug Den Hoed (AtAppStore Inc.)‚, via WF-Pro for providing this in another thread. (Super helpful)!!!

***Can there be another column that will display who the current task is assigned to??


Topics help categorize Community content and increase your ability to discover relevant content.

0 Replies


Level 10

I think it's something like this:

IF({numberOfChildren}=0,IF({canStart},IFIN({status},"CPL","FLG","",CONCAT("• ",{name},{assignedTo}.{name}," "))))

I just added {assignedTo}.{name} to the concatenation. Same column.

Because a collection can't be sorted, it has to be in the same column so the task and assignee line up.


Level 6

Thank you for quick reply @Randy Roberts‚ !

I couldn't get it to work...column appears blank. Sometimes there is more than one task ready to start and assignments would be different...idk if that's the problem?


Level 10

I'm sure it's just a syntax thing, we should be able to concatenate the task and assignedTo name.


Level 10

Here's the solution:

displayname=Current Task w Assignee





valueexpression=IF({numberOfChildren}=0,IF({canStart},IF(CONTAINS("CPL",{status}),"",CONCAT("• ",{name},"-",{assignedTo}.{name}))))



Level 10

Hmm. I'd expect likewise Randy.

Tegwyn, starting closer to home, I suggest you try this first, which I'd expect (messily) to bring back the ID of the primary assignee (from the Task, mind you) as a suffix behind each of the Task names:

IF({numberOfChildren}=0,IF({canStart},IFIN({status},"CPL","FLG","",CONCAT("• ",{name}," ",{assignedToID}," "))))

If that then works, one more baby step would be to try to hit the assignedTo object itself and return the (very same) ID:

IF({numberOfChildren}=0,IF({canStart},IFIN({status},"CPL","FLG","",CONCAT("• ",{name}," ",{assignedTo}.{ID}," "))))

If that (syntax) then works, like Randy, I'd expect his previous suggestion to work (but we know it already fails), so perhaps it is not "reachable", being in a collection (e.g. too many hops). If so (even if there is some elusive syntax that would do the trick), as a workaround, if you happen to already have a custom form on every Task of interest, you could add a calculated parameter (e.g. "Current Primary Assignee") with a formula of "Assigned To:Name" on each task, and then, having brought what you need "closer" (kinda) on the Task, try this:

IF({numberOfChildren}=0,IF({canStart},IFIN({status},"CPL","FLG","",CONCAT("• ",{name}," ",{DE:Current Primary Assignee}," "))))

Good luck: I'm interested to hear how you make out.




Level 6

yikers - but I understand ( see reply from Randy also....let you know how it goes