two value combined in field ,

everest226 — Sat, 16 Nov 2024 01:04:59 GMT

Membership field has value = 'NOT PROVIDED','LOW ENTRY', 'Gold','Diamond', 'Silver','Cooper',

I want to two value in one, like silver and cooper as silver and rest as usual , bellow is the syntax needed to be update

If(Upper([Membership])='NOT PROVIDED','LOW ENTRY',
Upper([Membership])) as [Membership],

Re: two value combined in field ,

sunny_talwar — Thu, 12 Mar 2020 15:07:06 GMT

May be this?

If(Match(Upper(Membership), 'SILVER', 'COOPER'), 'silver', 'usual') as NewFieldName