Formula clarity: If field X contains "this", field Y value = "that"

Panorama X
1

As sketched in the subject, I need a formula to make a piece of field X’s value determine the value of a field Y. For example, if field X contains “you’re invited”, the field Y value should be “A”. If field X does not contain that text, field Y’s value should be “B”.

How’s that done? It seems like a drop-dead simple thing, but I’ve already spent hours on the documentation and the formula workshop.

2

The formula would be

?(X contains "you're invited", "A", "B")

the statement might be

Y = ?(X contains "you're invited", "A", "B")

if you are just doing an assignment in the current record, or it could be

Field Y
FormulaFill ?(X contains "you're invited", "A", "B")

if you are filling the entire field.

2 Likes
3

So simple! I remember trying various versions of that but obviously none quite right.

Thank you, dave!