Update column Decision based on below inputs

[vinayvnn]

Hello Community, I have provided sample data here on my current task which I am working on and sample data provided below:

ID	Name	Start Date	End Date	Comment	Country of Citizenship	Decision	Decision Comments
1	a	1/1/2024	1/12/2024	Start assignment	China
2	b	1/1/2024	1/12/2024	Start assignment	US
3	c	1/1/2024	1/12/2024	Start assignment	India
4	d	1/1/2024	1/12/2024	Start assignment	Canada
5	e	1/1/2024	1/12/2024	Start assignment	UK
6	f	1/2/2023	1/12/2025	On going	China
7	g	1/2/2023	1/12/2025	On going	China
8	h	1/2/2023	1/12/2025	On going	US
9	i	1/2/2023	1/12/2025	On going	China
10	j	1/2/2023	1/12/2025	On going	India
11	k	1/2/2023	1/12/2025	On going	UK
12	l	1/2/2023	1/12/2024	End assignment	US
13	m	1/2/2023	1/12/2024	End assignment	UK
14	n	1/2/2023	1/12/2024	End assignment	China
15	o	1/2/2023	1/12/2024	End assignment	US

first I want to filter the country of citizenship to US and China and then if user input is Citizenship 1st year then I have to update column "decision" as "Yes" where there is "Start of assignment" in "comment" column

if user input is citizenship all years then we need to update the column "decision" as "Yes" wherever we have "start assignment / on going and end assignment" in column "comment"

if user input is blank on either of condition then decision should be blank and need not to update the column, could some one provide any leads? much needed help. Thanks in Advance

[OTrieger]

@vinayvnn 
There are different ways how to go about
1. filter out US And China and then create the conditions with Formula tool
2. with the use of IF function with a Formula tool you will be able to do so. So if country is US or China do the condition.

[kamanivk]

Use Formula tool, Select Decision column and add formula based on the conditions you need.

For Example:

IF [Input Column] = "Citizenship 1st year" and [Comment] =  "Start of assignment"

THEN [Decision] = "Yes"

ELSE [Input Column] = "citizenship all years" and ( [Comment] = "Start assignment" or [Comment] = "On going" or [Comment] =  "End assignment" )

THEN [Decision] = "Yes"

ENDIF