select multiple values

[ali_hijazi]

Hello

I got a trigger on one of the sheet and added an action to select multiple values of a field

the field is Business Type

the values are OFFICE and REGIONAL OFFICE

I put in the action the field [Business Type] and in the value I put (REGIONAL OFFICE|OFFICE)

Only OFFICE is selected

values that contain spaces are not being selected

Please advise

[jonathandienst · Accepted solution]

Hi

Try replacing the spaces with *

(REGIONAL*OFFICE|OFFICE)

That appears to work.You can use Replace() to swap the  space for a *

Regards

Jonathan