Jan 09, 2019 07:53 PM
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!
Jan 09, 2019 09:08 PM
IF(
FIND('Example Product',Products)
'EP'
) &
IF(
FIND('Example Lite',Products)
'EL'
) &
IF(
FIND('Example Any',Products)
'EA'
) &
etc...
Jan 09, 2019 09:57 PM
Thanks @Jeremy_Oglesby