Formula Help

Platform discussions Special workflows & use cases
,
1

Hello- I need some help with a formula. Below is the formula AI provided me in Monday. Here’s the issue: I have the first column- Name. Within this column is first + last name or first name only. My goal is to extract the first name into a new column. If Jane Doe in column ‘name’, pull Jane only. If Jane in column ‘name’ pull Jane. The formula works for Jane Doe examples but not Jane.

IF(SEARCH(" “, {Name}) > 0, LEFT({Name}, SEARCH(” ", {Name}) - 1), {Name})

2

Hi @ShannonTW,

Try:

REGEXEXTRACT({Name}, "^[^ ]+")

Want to take your formulas to the next level? Try the Advanced Formula Booster, the app that reinvents formulas in monday.

  • Create formulas without using the Formula column (and avoid its limitations)
  • Build formulas involving data from the previous item, the next item, the sub-items, the parent item, even items in the same group or the same board.
  • In one formula, update multiple columns from multiple items.

Check our blog for real use cases.