edit gallery view to only see active

Like (0) Share

Report

Posted on 7 Feb 2021 22:16:21 by Matt383

405

I have a choice column in sharepoint list named "status" and the options are active, pending, completed. I want the gallery to only show active and pending. I can get it to come up with Filter ('SP Job Request',Status.Value="Active") but need to show active and/or pending. Can you please assist?

Categories:

General Questions

All responses (2)

Answers (1)

Matt383 405 on 07 Feb 2021 at 23:15:39

Like (0)

Report

Re: edit gallery view to only see active

Thank you, works a treat 🙂
Verified answer

Pstork1 67,158 Most Valuable Professional on 07 Feb 2021 at 23:09:00

Like (1)

Report
Re: edit gallery view to only see active

Try the following

Filter ('SP Job Request',Status.Value="Active" || Status.Value="Pending")

Or since there are only three possible values

Filter ('SP Job Request',Status.Value<>"Completed")