Nested IF Statements as a Script

[Callum_Green]

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

[Vivid-Squid · Accepted solution]

You are looking for SWITCH().

Airtable Support

An alternative to IF statements using SWITCH()

SWITCH() is one of Airtable’s most recent additions to the formula field, and it can be a big time-saver when you’re working with conditional-heavy formulas (e.g. nested IF statements).     To dem...