I have a field in my table called ProductDescription
I would like to filter some words to make a category
|ProductDescription (text field)||Category (What I would Like) (calculation)|
|Wine Glass Golden||Golden|
I have tried this and it doesn't work
FilterValues (ProductDescription; "Golden" ="Golden"); "Golden";
FilterValues (ProductDescription; "Silver" ="Silver"); "Silver";
Thanks for all your help!