Extracting a singel word from a field

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

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.

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.