Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Nested IF Statements as a Script

Topic Labels: Scripting extentions
Jump to Solution
367 1
Showing results for 
Search instead for 
Did you mean: 

I have a field that needs translating into a form that can be used by a second program, but there are some 50-60 options that need translating and the IF statement got huge.

Essentially it goes:

IF Cell A = “Manager”, “X”, IF Cell A = “Worker”, “Y” …

It only needs to be done once, so would it be possible to use a script? The find and replace one looks almost perfect, but rather than replacing the value, I want the new value pasted into a separate cell

1 Solution

Accepted Solutions

You are looking for SWITCH().

See Solution in Thread

1 Reply 1

You are looking for SWITCH().