Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

IF MANY question

1316 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...