Skip to main content

I’m using the following formula to take a value from a single select field {Products} and store a code.


IF(
{Products}='Example Product',
'EP',
IF(
{Products}='Example Lite',
'EL',
IF(
{Products}='Example Any',
'EA',
IF(
{Products}='Some Ref',
'SR',
IF(
{Products}='Some Cloud',
'SC',
IF(
{Products}='Any Sample',
'AS',
IF(
{Products}='Good Sample',
'GS',
IF(
{Products}='Part Pro',
'PP',
IF(
{Products}='Example Reg',
'ER'
)
)
)
)
)
)
)
)
)

I need to change the {Products} field from a single select to a multi select and therefore allow multiple products. The formula should store one or more product codes. Is it possible to adapt the formula to support that? Many thanks!

IF(
FIND('Example Product',Products)
'EP'
) &
IF(
FIND('Example Lite',Products)
'EL'
) &
IF(
FIND('Example Any',Products)
'EA'
) &
etc...

IF(
FIND('Example Product',Products)
'EP'
) &
IF(
FIND('Example Lite',Products)
'EL'
) &
IF(
FIND('Example Any',Products)
'EA'
) &
etc...

Thanks @Jeremy_Oglesby


Reply