I have a table and one of the columns is PO #.
I’d like to make this an enum with the ability to add new POs to the list but to restrict the PO list by the customer.
This Valid IF formula is what i had in mind…
=SELECT(Current Billing[PO #],[Facility]=[_THISROW].[Facility])
but when i do this it removes the ability to add a new one.
Facility is NOT the column to the left of PO #. I’d prefer not to make another table to house the POs.
I already have too many tables.
Id prefer not to make a new table to house this PO data.