I am trying to get the time of appointment into the G Sheet we are sending this data to. It came in perfectly once and now it is a decimal, see screenshot. Any ideas? I already re-formatted the column in the spreadsheet to include time.
Page 1 / 1
Hi
Change the Format of the Column values in GSheets.
Hi there, 
Did Troy’s suggestion to reformat the column again in Google Sheets help fix the appointment times? Or are the times still displaying incorrectly?
If they’re still not right, I’d suggest turning the Zap off, reformatting the column again, and then turn the Zap back on. Just thinking that it could be that the previous formatting is being cached by the Zap somehow. 
In which case turning the Zap off and on again to refresh it’s connection to the spreadsheet may help clear that.
Want to make sure you’re all set, so please keep us posted on how it’s going!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.