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?