topic Adding actions to sheets in App Development

Adding actions to sheets

lea_ternat — Fri, 03 Jan 2025 14:45:42 GMT

Hello,

I want to add a filtre in a sheet using : Select values matching search criteria

How can I define one criteria with two values. For more precision, I want to filter with : Match(yean,'2024','2025')

However, the action doesn't apply

Thanks for your help.

Re: Adding actions to sheets

Clement15 — Fri, 03 Jan 2025 15:00:59 GMT

Hello,
You must use 'Select values in Fields' with this syntax:
Field1;Field2

Re: Adding actions to sheets

lea_ternat — Fri, 03 Jan 2025 16:02:22 GMT

Thanks Clément15

Re: Adding actions to sheets

MatheusC — Fri, 03 Jan 2025 16:53:43 GMT

@lea_ternat
You may also want to leave the years to change dynamically, so following the same principle as solving the @Clement15 .

='$(=year(today())-1);$(=year(today()))'

- Regards, Matheus