Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a Filed name "ListOfChanges" in the List box as a filter. The field has many many values under it from which I just need to show a few.
So how can I achieve this? Showing only a few values for Selection instead of ALL the values under the particular field.
TIA
You could create a calculated field like
=If(Match(ListOfChanges,'Change1','Change2'), ListOfChanges)
(enter in <expression> field on general tab)
No, Doesn't Work, No change.Attaching a Screenshot of where I entered the Expression. Hope I am entering it at the right place. I entered the expression at two places but no change.
You can create like this too
=If(Wildmatch(ListOfChanges,'RequiredValue1','RequiredValue2','RequiredValue3',....), ListOfChanges)
No. Still able to see all the values under the field name.
Select <expression> from the field dropdown on general tab, and input the calculated field expression.
Yup, works. Thanks a Lot