BookmarkSubscribeRSS Feed
Choose Language Hide Translation Bar
jasongao

Not applicable

Joined:

Jan 2, 2019

need help with a simple formula

have a column

A

A1

A3

Af

B3

Bt

need to create a new column with formula: if the first column value contains A, then the second column value is set as A, otherwise set as O, like this

A A

A1 A

A3 A

Af A

B3 O

Ct O

Thanks!

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Thierry_S

Not applicable

Joined:

Apr 19, 2018

Solution

Re: need help with a simple formula

If( Contains( :Column 1, "A" ),
"A",
"O"
)

Thierry R. Sornasse
uday_guntupalli

Community Trekker

Joined:

Sep 15, 2014

Solution

Re: need help with a simple formula

@jasongao
        

If( Contains( :Column 1, "A" ),
	"A",
	"O"
  )

image.png

 

Best
Uday
3 REPLIES 3
Highlighted
Thierry_S

Not applicable

Joined:

Apr 19, 2018

Solution

Re: need help with a simple formula

If( Contains( :Column 1, "A" ),
"A",
"O"
)

Thierry R. Sornasse
uday_guntupalli

Community Trekker

Joined:

Sep 15, 2014

Solution

Re: need help with a simple formula

@jasongao
        

If( Contains( :Column 1, "A" ),
	"A",
	"O"
  )

image.png

 

Best
Uday
jasongao

Not applicable

Joined:

Jan 2, 2019

Re: need help with a simple formula

perfect! Thanks guys!