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
How do i get around this for now until fixed?
Convert the date as a string likeโฆ CONCATENATE(DAY([Date]),"/",MONTH([Date]),"/",YEAR([Date]))
User | Count |
---|---|
42 | |
25 | |
24 | |
19 | |
15 |