What is the trick to converting the app sheet timestamp date format to be recognised by smart sheet? On the face of it both look to be the same.
timestamp format from within smartsheet is = 3/3/2018 11:48:41
timestamp format inputted from appsheet = 3/3/2018 11:48:41
I tried the DATEONLY() function on the app sheet date and got "#invalid data type" error but it works for the smart sheet created timestamp column.
As I have 3 timestamp columns updated from appsheet i can't just use the smartsheet create or modified column types.
I need the output in date format as i use it to calculate labour productivity per week / month
thanks in advance
Brad