Valid If in a ref column to show specific values

AppSheet AppSheet Q&A
1

I have two tables Snagging and Project Admin.

Column ’ Job Ref’ in Snagging is a reference to the column ‘Job Number’ in Project Admin. Within Project Admin, there is another column called ‘Type’ and the values are either Client or Internal.

So, within Snagging I only want to show values in the ‘Job Ref’ dropdown when the related ‘Job Number’ is ‘Client’.

I am struggling to work out the Valid If for the reference field.

2 
[SELECT](https://support.google.com/appsheet/table/10104782?hl=en&ref_topic=10099895,10173496,10099316,#query=select()(Project Admin[Job Number], [Type] = "Client")
1 Like
3

If I was to add another condition into the same expression, how would that work?

I’d like [Status] = Open to be added in as well as [Type] = Client

4

Review the AppSheet Help article for the SELECT function that I linked to, as well as the [AND](AppSheet function list - AppSheet Help article.

SELECT(Project Admin[Job Number], AND([Type] = "Client", [Status] = "Open"))
1 Like
5

Thank you. I had the AND function at the front hence not working.

1 Like