This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
SWITCH() statement does it perfectly well for me
=SWITCH({DERIVED FIELD},"SOURCE VALUE 1", "DERIVED VALUE 1", "SOURCE VALUE 2", "DERIVED VALUE 2", "SOURCE VALUE 3", "DERIVED VALUE 3", "SOURCE VALUE 4", "DERIVED VALUE 4", "SOURCE VALUE 5", "DERIVED VA...