HOW TO USE SELECT FUNCTION ON A SLICER

AppSheet AppSheet Q&A
1

I need help with the right expression for below

SELECT(Ticket[category],[created_by]=USEREMAIL())

,ISNOTBLANK([ABC_Comment])

,[status]<>‘Completed’)

NOTE: I want to display slicer only if the column ABC_Comment is not blank and status is not yet Completed from a Ticket table. Category is also a column in Ticket table

2

Are you saying you are using this in a slice? Or what is ‘slicer’? If you are using it in a slice you need to return the key column value vs Ticket[category] unless [category] is your key column.

3

Achiever2023_0-1709671501263.png
Achiever2023_0-1709671501263.png1299×867 58.3 KB

Here is the screenshot,

4

You are a bit all over the place here. Does your Tickets table have a [Email] column?

5

The result of the formula needs to be TRUE or FALSE. To do that, you need to use..

AND([created_by]=USEREMAIL(),ISNOTBLANK([ABC_Comment]),[status]<>‘Completed’)

1 Like
6

oh sorry, created_by

7

@AleksiAlkio answer should resolve your problem.

8

Worked!

Thank you

9

yes, thank you for sharing insight too.