Space in Value not working for Select Field Value for Action of Sheet

[nishika]

[Michiel_QV_Fan]

'Multiple UOM'

[nishika]

Not working

[theoat]

Try :
='Multiple UOM'

[anat]

try by giving double quotes

"Multiple UOM"

[theoat]

You will have an error with double quotes.
The correct syntaxe is :
='Multiple UOM'

[Michiel_QV_Fan]

yep, forgot the = sign as @theoat correctly points. 

[theoat]

Can you put the answer as a solution to close the topic?

Thank you.

[nishika]

All of these solutions  are  not working

[nishika · Accepted solution]

It is working with Select values matching search criteria