How do I do a select list as well as add an addition to the list of text in quotations?
My select Statement is as follows though I also just want to add an entry to indicate that the user has deliberately stated that the field is blank such as “” or “Not Specified”
=Select(Contact_Records[Full name], [address]=[_ThisRow].[Address])
It this possible or I do I have to go about it another way. I then need the rest of the contact information to pull down for other fields in the form.