Question

Anyone have a Formula to convert Names into correct Plural and Possessive

+9

I assume there is not formula reference for this. Is there anyone with prebuilt formula that will identify when to use the s, ‘s, or es on a name? To comply with the standard English rules here: https://www.merriam-webster.com/grammar/what-happens-to-names-when-we-make-them-plural-or-possessive

I’m sure I could take 2+ hours figure it out, unless you by chance have it 😀

+3

Plural

IF(
  REGEX_MATCH(LOWER({Name}), '(s|x|z|ch|sh)$'),
  {Name} & "es",
  {Name} & "s"
)

Possessive

IF(
  REGEX_MATCH(LOWER({Name}), 's$'),
  {Name} & "'",
  {Name} & "'s"
)

+9

@dgatlin-ebay Beast Mode! Thanks, I dont use REGEX so that’s even better! I realized I needed two different fields so that's perfect. 🥳

2 replies