Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Greeting everyone!
I cannot find the sintax for the "select values in a field" action in a sheet.
I have the field "InvoiceMonth" and the values are 202201, 202202,202203 etc...
I would like to select only the first three month, I tried A LOT of combinations, both with semicolon ad not (this is the only hint I found in the documentation here).
Thank you so much for the help
have a nice day!
Choose "Toggle Field Selection" instead of "Select values in field" and try below with single quotes
='(202201|202202|202203)'
Try as below
(202201|202202|202203)
This error message appears:
Error in expression: ')' expected.
Both starting with and without '='
Choose "Toggle Field Selection" instead of "Select values in field" and try below with single quotes
='(202201|202202|202203)'