Slice to be used to display columns based on two criteria

AppSheet AppSheet Q&A
,
1

I want to create a slice that will be used to display column data based on two criteria from the following data:

ringAlertData.PNG
ringAlertData.PNG1521×218 21.6 KB

If I create a Slice using this data and expression, it works to display the start data column:

  1. [extractTime] = [Start]

extractTimeStart.PNG
extractTimeStart.PNG367×214 6.95 KB

If I create a Slice using this data and expression, it works to display the End data column:

  1. [extractTime] = [End]

extractTimeEnd.PNG
extractTimeEnd.PNG348×182 6.28 KB

When I use either of these expressions individually, they work as expected. However, when I try to combine them together using this script, I don’t get any results:

AND([extractTime] = [Start], [extractTime] = [End])

Any ideas as to how I can combine these two together?

2

You might be using AND() where you should use OR().

Your current expression requires that the selected column has both conditions to be true:

  1. [extractTime] = [Start], AND 2. [extractTime] = [END]

This means that for a row to match, its [Start] must be equal to [END]. I don’t think this is the intended behavior.

OR() | AppSheet Help Center

3

Yes. OR() works! Thanks!

My logic was that if it is true for both [extractTime] = [Start], AND [extractTime] = [END], then I would use an AND(). However, it appears I need to use the OR() instead.

4

This logic means [Start] = [END] :slightly_smiling_face:

By the way, in your case it would be more efficient to use IN() as:

IN([extractTime], LIST([Start], [END]))

IN() | AppSheet Help Center