Slice Row Filter: Can I do multiple Priority Enum?

AppSheet AppSheet Q&A
,
1

Hey everyone! Ran into a little issue with managing row-filter on slices.

For context, I have a list of clients on a table grouped by Priority (High, Medium, Low, and Archive). So far I’ve had success with using row filter on slices for filtering a single Priority enum, but having difficulty with trying to use Row Filter for two or more enums of the Priority. For example:

  • [Priority] = “Archive (Paid/Closed Accounts)” → works like a charm when only one enum of the Priority is being selected.

Now I’ve tried to do the same function, but with multiple enums for example:

  • [Priority] = “Low Priority”, “Archive (Paid/Closed Accounts)”
  • AND([Priority] = “High Priority (Program Uploads)”, [Priority] = “Medium Priority”

And unfortunately, these have not worked out. I have double-checked to make sure the slice has the appropriate columns selected to be seen on the Slice View, but when I enter these functions my table is completely blank. Any ideas?

2

There are many ways. You can create another table like this

Priority ID (Key) Priority
1 Low Priority
2 Medium Priority
3 High Priority

You can make your current [Priority] Column to EnumList and Basetype to REF and reference table to the newly created table.

You may create another column hidden [Sort order] and app formula SUM([Priority]).

In Ux>Sort by You can use this column to sort the table.

3

AND will not work, since [priority] will only match one case not all of them. You should instead use OR, or even better use IN() such as:

IN([priority], {“priority 1”, “priority 2”, “priority 3”})

IN() | AppSheet Help Center

1 Like
4

This definitely helped me out, thank you so much!!

1 Like