Hello,
I am trying to create a custom column based on the name of a project. It is a task report and I want to show the custom field 'Parcel Ref' at the project level if the project name contains 'RE Task' or show the custom field 'PP Parcel Number Ref' at the project level if the project name contains 'PP Tax.' I have tried both of the following and it is not working. Any ideas?
valueexpression=CONCAT(IF(CONTAINS(RE Tax,project:name),{DE:project.Parcel Ref},IF(CONTAINS(PP Tax,project:name),{DE:project.PP Parcel Number Ref},""),""))
valueexpression=CONCAT(IF(CONTAINS(RE Tax,{project}.{name}),{project}.{DE:Parcel Ref},IF(CONTAINS(PP Tax,{project}:{name}),{project}.{DE:PP Parcel Number Ref},""),""))