IF AND

AppSheet AppSheet Q&A
1

Hi,

I’m trying to make an IF statement so it says Yes and No for different values but I am having trouble with the expression.

IF (CONTAINS([owner],“57”),“Yes”,“No”)

IF (CONTAINS([owner],“76”),“Yes”,“No”)

IF (CONTAINS([owner],“12”),“Yes”,“No”)

I’m trying to combine these but it only comes up as it’s reading the first one.

Any suggestions

2

Hello @Fre3 , you can try this expression:

"Contains 57: "&IF(CONTAINS([owner],"57"),"Yes","No")&
", Contains 76:"&IF (CONTAINS([owner],"76"),"Yes","No")&
", Contains 12:"&IF (CONTAINS([owner],"12"),"Yes","No")
1 Like
3

The expression itself works but I’m not getting a Yes or No value in the rows

4

If it’s saved as an app formula then it will only appear on new rows, is that the case?
Also, do you need just one “Yes” or a concatenated explanation of which gets “Yes” or “No”?

1 Like
5

Yeah, when I make a new row it has an N in the box. I wanted it so the initial value of 57 says yeah if it’s in the chosen column [owner] but I also wanted it so different value’s also said Yes as well as the 57 if that makes sense

6

sort of like an and statement but again I don’t know how to express that

7

Is the column type set as “Text”?

8

Yes/No

9

If i change it to text I just get the whole expression in the box

10

@Rafael_ANEIC-PY

Any luck?

11

I’m not quite sure what is the result that you want, here are two examples, tell me which one it is that you need:

example 1: [owner] = “57335”

Result option 1:
Contains 57: Yes, Contains 76:No, Contains 12:No

Result option 2:
Yes

example 2: [owner] = “12444”

Result option 1:
Contains 57: No, Contains 76:No, Contains 12:Yes

Result option 2:
Yes

1 Like
12

I wanted a Yes or No answer based off if the given numbers were in the text. The other expression you gave me before worked I just didn’t refresh/save changes. Thank you

1 Like