Task report grouping with an IF statement ("No Value" name replacement) | Community
Skip to main content
RandyRoberts
Community Advisor
Community Advisor
April 21, 2020
Question

Task report grouping with an IF statement ("No Value" name replacement)

  • April 21, 2020
  • 3 replies
  • 710 views

Hi all,

I have a task report that is grouped by assignedTo:name. All the rows are grouped by assignee name except for the "No Value" group of tasks that are assigned only to a team or role.

I would like to highlight this particular group by changing No Value to " Hey, you guys need to assign these tasks!" instead of "No Value", or something like that.

I've tried an IF statement right in the grouping but couldn't figure that out.

I've tried the below three calc field attempts on a task form to maybe group by that but keep getting "Calculation Not Valid":

IF({assignedTo}.{name}="No Value",ABCD,{assignedTo}.{name})

IF(ISBLANK({assignedTo}.{name}),"ABCD" ,"assignedTo:name")

IF(ISBLANK({assignedTo}.{name}),"ABCD" ,{assignedTo}.{name})

Has anyone done this successfully? it seems easy until I tried to do it. Am I even thinking about it the right way? It's probably just a syntax problem but still.

Thanks

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

3 replies

RandyRoberts
Community Advisor
Community Advisor
April 21, 2020

If I use a calculated field, that means I'll probably have to add that form to every single task in every single project. That's not gonna work. That's a LOT of overhead for one report.

RandyRoberts
Community Advisor
Community Advisor
April 21, 2020

Got it!

textmode=true

group.0.displayname=•

group.0.namekeyargkey.0=assignedTo

group.0.namekeyargkey.1=name

group.0.valueexpression=IF(ISBLANK({assignedTo}.{name}),"These tasks have not yet been assigned!!!" ,{assignedTo}.{name})

group.0.valueformat=string

group.0.namekey=view.relatedcolumn

group.0.linkedname=assignedTo

kynabaker16
Adobe Employee
Adobe Employee
April 21, 2020

Hey Randy! Thanks for posting your thought process and your ultimate answer! I'm sure this will be helpful to others!