Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hello,
You must use 'Select values in Fields' with this syntax:
Field1;Field2
Hello,
You must use 'Select values in Fields' with this syntax:
Field1;Field2
Thanks Clément15
@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