I have a strange error,
A have a computed Key based on 3 pieces of information the customer name, appt date and quote number. Now only for this specific row has it decided to take the Appt Date as a US format. 1. the spreadsheet settings are Australian
- the App data Tables localize settings are australian 3. the row is definitely in the Spreadsheet.
How do i get around this for now until fixed?