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 Custom Column View

Avatar

Employee
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},""),""))
0 Replies

Avatar

Level 1
Hi Sarah, Just to check, you have two fields at the project level called "Parcel Ref" and "PP Parcel Number" and you want this custom field to display the value of either Parcel Ref or PP Parcel number depending on the name of the project? Cheers, Iain