I would like to compile a virtual column whic...

(Troy Bourne) #1

I would like to compile a virtual column which would concatenate all of that rows enum list answers that contain “servic” (basically needs 'servic’e or requires 'servic’ing)

Is there an easy/efficient way to do this? this would allow ‘at a glance’ service needs when reviewing an inspection report.

Thank you!

(Dinh Nguyen Nguyen) #2

You can try something like this:

CONCATENATE (

IF(CONTAINS([column1], “servic”), [column1], “”),

IF(CONTAINS([column2], “servic”), [column2], “”),

IF(CONTAINS([column3], “servic”), [column3], “”),

)

The idea is to check each column to see if it contains “servic”. If it does, then we concatenate the column text. If not, we simply concatenate a blank text.