Need a formula to return a first word

Swetha

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.

Paul McGuinness

Hi @Swetha

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