Extracting a singel word from a field

[Sam_Giovenco]

I am looking to extract a specific word in a column and only return that word otherwise blank. For example if i have multiple words in rows like:
Open
Closed
In progress
I want to show in a new column just “open”

I will then repeat to show “closed”

Any help is appreciated

Thanks

[JonathanBowen]

Hi @Sam_Giovenco - a simple solution to this uses a formula:

IF(
  FIND('open', LOWER(Notes)) > 0, 
  'Open',
  IF(
    FIND('closed', LOWER(Notes)) > 0, 
    'Closed'
  )
)

You could extend this to a few more words without much trouble. You might get some weird edge cases if, for example, the Notes field contains “open” and “closed”. In my formula above, this record would show as “Open” as this is the first condition that resolves to true, which might not be what you want.