Help

IF MANY question

1217 2
cancel
Showing results for 
Search instead for 
Did you mean: 
nnnnneil
8 - Airtable Astronomer
8 - Airtable Astronomer

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!

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