We use a custom list to log keys signed out from our office. One of the columns is a Single Line of Text column titled 'Signed Out To'. In this column we enter the name of the person receiving the key, and the company they work for. However, we would like to enforce a certain type of input i.e. FIRSTNAME SURNAME (COMPANY NAME) to ensure uniformity of entries.
Can the column validation function enforce this, and if so what would be the formula?!