Skip to content

Instantly share code, notes, and snippets.

@jack-williams

jack-williams/IF_TYPE Secret

Last active September 23, 2023 14:58
Show Gist options
  • Star 4 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save jack-williams/5859d170fcb363dad1620c4d40770527 to your computer and use it in GitHub Desktop.
Save jack-williams/5859d170fcb363dad1620c4d40770527 to your computer and use it in GitHub Desktop.
Download ZIP
Type Predicates
Raw
IF_TYPE
IFBLANK = LAMBDA(value, value_if_blank,
IF(ISBLANK(value), value_if_blank, value)
);
IFNUMBER = LAMBDA(value, value_if_num,
IF(ISNUMBER(value), value_if_num, value)
);
IFTEXT = LAMBDA(value, value_if_text,
IF(ISTEXT(value), value_if_text, value)
);
IFLOGICAL = LAMBDA(value, value_if_logical,
IF(ISLOGICAL(value), value_if_logical, value)
);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment