Set view condition

[MichelleUK]

I have a UX view which is a table. There is a column which is called status and these are the options for this column:

Not Started

In Progress

Deferred

Completed

"Blank"

I would like my view to show only open items (highlighted green text) so the condition would be:

Show items which are not = completed and are not empty.

Please advise the formula to use.

Thanks

[Steve]

Slice row filter conditions - AppSheet Help

[Swoopy · Accepted solution]

Like @Steve suggest, you need to create a slice for this view. Name the new slice, select the 'Source table', and then place the following expression in 'Row filter condition'.

AND(ISNOTBLANK([columnName]), [columnName] <> "Completed")

Now go to the UX view and select the new slice name in 'For this data'

P.S. AppSheet is less-coding platform but you really need to know where to go. I'd say it's quite complicated for newbies.

[MichelleUK]

Thank You!

[EmadK]

Hi Swoopy, would this work on a view that is in a filtered dashboard?

Show the "Warning Label" view on the dashboard when the cell has a value:

Hide when the cell is empty:

The expression I am using on the UX view: (could be totally wrong;/)

AND(
IN(Pick Up Plan[Family ID], Filter[Family ID]),
ISNOTBLANK(Pick Up Plan[Warning & Action])
)

 Could you help, please.

[Swoopy]

---

@EmadK wrote:

The expression I am using on the UX view

---

Where is the expression saved in the UX view?

[EmadK]

It's saved in the Show if option.

Will that work for a details view on a filtered dashboard?

[Swoopy]

---

@EmadK wrote:

The expression I am using on the UX view: (could be totally wrong;/)

---

The expression valuates the datasets, would not respond to view's entries. Try using dynamic option of dashboard view instead.

[EmadK]

Thank you. I am not if I understand how dynamic dashboards work. Can you explain that, please?

[Swoopy]

There're plenty of guides & documents about that, check out on youtube or google. I'm not doing step-by-step guide here, sorry.