How do I do a select list as well as add an a...

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.

0 4 447
4 REPLIES 4
Top Labels in this Space