nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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!

Accepted answers

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

uday_guntupalli

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

All comments

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

uday_guntupalli

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

perfect! Thanks guys!

Quick Links