Miscellaneous utilities

CASE – Find given key in list

126 views June 1, 2018 admin 0

Overview

This Custom Field finds the given key in a list of key/value pairs and returns the matching value.

Syntax

CASE(FIELDSTR(value),1,ABC,2,DEF,3,GHI)

Element Description
Text Text to search
Key Key to search for
Value Matching Value

Example

CASE(2,1,ABC,2,DEF,3,GHI) returns DEF.

See also

PARTSTR

Was this helpful?