Help with Validity Expression

[RPAdam]

Hi there,

I’m a total beginner with appsheet and just helping out with the app we use at work.

We have a spreadsheet of materials from a few suppliers with their own supplier part numbers.

We use the supplier part number as a reference number to pull up the material specs. however one of our suppliers changed their part number last year and so we now have two sets of part numbers.

I want to keep the old part numbers for our database of previous built products

But when a new product is being built, i only want the new part numbers to be selectable in the drop down list.

As you can see below i have put a column on the end labelled “Current” and have gone done with ‘Y’ or a ‘N’

I’m just struggling to get an expression to work in the validity section

Any Ideas or a work around?

Cheers

Adam