Need a formula to return a first word

If column has values NET or NET12 or NET,WEB or NET12,WEB or NET34,WEB12 value needs to be return as NET also, if values has Test or Test12 or Test Test, Prod or Test12, Prod or Test 34,Prod56 value needs to be returned as Test. If it is Dev_Unit_test, same value needs to be returned as Dev_Unit_test.

Find more posts tagged with

Accepted answers

All comments

Paul McGuinness

This should deliver what you need, tested as below.

Formula is

=IF([Column4]@row = "Dev_Unit_test", "Dev_Unit_test", IF(CONTAINS("Test", [Column4]@row), "Test", IF(CONTAINS("NET", [Column4]@row), "NET", IF([Column4]@row = "Dev_Unit_test", "Dev_Unit_test", "Other"))))

Hope that helps

Thanks

Paul

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.