Hi!,
When I add a new row to [Job] an extra character is added to text in a column, [Cusotmer ID]. In the app i select a customer by name, and the app fills in the customer info such as customer ID. That column for customer ID that is used to pull data into the sheet via a Vlookup sheet formula. Because that character is in the, the vlookup returns โErrorโ in multiple fields.
Its adding an apostrophe before customer ID
Iโd guess the spreadsheet column type is not plain text or Automatic. Is that the case?
User | Count |
---|---|
41 | |
25 | |
25 | |
17 | |
11 |