filter results in template

[areyes]

Hi everyone, appreaciate your help to figure this out:

I’m working on a template in Google Docs where I need to pull a list of devices installed at a site from a child table called “Dispositivos.” However, I only want to include devices from two specific brands, rather than showing all devices in the report. In my case, I need to filter the data to only show Brand 1 and Brand 2 devices. How can I achieve this?

I already tried, something like this, but it didn’t work:

Appreaciate your help

[AleksiAlkio]

You need to use SELECT() with the START: expression.

[areyes]

Thank you! I did the changes and worked:
<<Start: SELECT(Dispositivos[HARDWARE ID], AND([Task ID]=[_THISROW].[Task ID], IN([Brand], {“Hanwha”, “APC”})))>><<[Description]>>

[AleksiAlkio]

Excellent!