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

[Troy_Bourne]

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!

[Harry2]

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.