I have column with data type, and both table and spreadsheet locale is set as UK, ie. the data format is to be Date/Month/Year. When I enter date to this column through the app, app picks up the date in the correct format.
At the same time, i use this date column for another column. This column have app formula like this.
[Inspection ID]&" -
However, this returns the text : Inspection ID -
Obviously the app formula is returning US date type.
Any idea, how can we fix this problem so that we correctly pick up the date format in app formula?