(How to ?) Slices with multiples row filter condition

Hello,

How can i build a slice with multiple row filter condition ?

Exemple, i would like to show only “no” of a column containing “yes”, “no”, “maybe”.

What correct expression(s) i have to use ?

Thanks :slight_smile:

([Column] = "no") would appear to be all you need based on your vague question.

Ahah ! Sorry. I reread myself and indeed, my question is weird.

I specify : imagine i have X possibles row filter condition (“maybe”, “one day”, “too late”, “no of course”, …). On these, i just want to show Y (“yes”, “its ok”, “for sure”).

What is the correct expression ?

1 Like
OR([Column] = "yes", [Column] = "its ok", [Column] = "for sure")
2 Likes

Maybe:

	AND(
		[Column] = "yes",
		[Column] = "its ok",
		[Column] = "for sure"
	)
2 Likes

It’s ok !

Thanks all

2 Likes

No Problem, appsheet is great. you will see.

3 Likes

Another approach:

IN([Column], {"yes", "its ok", "for sure"})
5 Likes

Hey Steve, How would you take a sentence of words and split each word into list? This could be the solution to my question.

You could try splitting on a space: SPLIT([Column], " "). The problem with that is punctuation would fall in with words. So SPLIT("Hi, my name is Steve!", " ") would give:

  • Hi,
  • my
  • name
  • is
  • Steve.

Notice the punctuation in Hi, and Steve..