Skip to main content

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 😀

 

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"
)

 

​@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. 🥳

Reply


Terms & Conditions