Help with formula to populate new column

[Earl40]

Hello,

I have formula based on the data below where it searches for a work in the description column then populates a new column based on the search. I want to find a way to add a new step where if the result is blank based on the first part of the forumal then it checks other criteria then populates if conditions are present. Screenshot of my current formula below

Looking to add if the result is blank then check if Assigned buy = Mike or George, Source = Auto, Type = Case and rule isnt blank. Thank you in advance

ID #	Received Date	Assigned by	Source	Type	Rule	Description
1	9/1/2024	George	Manual	CASE		Legal - blablabla
2	9/2/2024	Mike	Manual	CASE		XYZ - blablabla
3	9/3/2024	AUTOMATIC	Manual	CASE		XYZ - blablabla
4	9/4/2024	George	Manual	CASE		XYZ - blablabla
5	9/5/2024	Mike	Manual	CASE		XYZ - blablabla
6	9/6/2024	Steve	Manual	CASE		XYZ - blablabla
7	9/7/2024	Robert	Manual	CASE		XYZ - blablabla
8	9/8/2024	Robert	Manual	CASE		Compliance - blablabla
9	9/9/2024	Robert	Manual	CASE		Compliance - blablabla
10	9/10/2024	George	Manual	CASE		Media - blablabla
11	9/11/2024	Mike	Manual	CASE		Media - blablabla
12	9/12/2024	Mike	Manual	CASE		XYZ - blablabla
13	9/13/2024	Mike	Auto	CASE	Amount Violation	1 ABC
14	9/14/2024	Mike	Manual	CASE		XYZ - blablabla
15	9/15/2024	Mike	Manual	CASE		XYZ - blablabla
16	9/16/2024	Mike	Manual	CASE		XYZ - blablabla
17	9/17/2024	AUTOMATIC	Manual	CASE		XYZ - blablabla
18	9/18/2024	AUTOMATIC	Manual	CASE		XYZ - blablabla
19	9/19/2024	AUTOMATIC	Manual	CASE		XYZ - blablabla
20	9/20/2024	Mike	Manual	CASE		XYZ - blablabla
21	9/21/2024	Steve	Manual	CASE		XYZ - blablabla

[ryan_mayu · Accepted solution]

@Earl40 

pls see if this is what you want. you can replace the "XXXXX" to the expected output.

category = SWITCH(TRUE(),

SEARCH("Legal",'Table'[Description],1,0)>0,"Legal",

SEARCH("XYZ",'Table'[Description],1,0)>0,"XYZ",

SEARCH("Compliance",'Table'[Description],1,0)>0,"Compliance",

SEARCH("Media",'Table'[Description],1,0)>0,"Media",

'Table'[Assigned by] in {"Mike","George"}&&'Table'[Source]="Auto"&&'Table'[Type]="Case","XXXXX")