I'm importing data into a Google Sheet via Integromat. Column A is a Date and Column B is a time. Both columns have been selected and formatted appropriately (Format > Number > Date and Format > Number > Time).
Things have been working perfectly but all of a sudden when new rows are added via Integtomat, instead of the correctly formatted date & time I'm getting an unformatted number. For example, 44560 instead of 12/30/2021 and .5833333333 instead of 2:00:00 PM. If I select an entire column and go to Format > Number I can see that the formatting is still applied. But in order to get the new row to format correctly, I need to reapply the formatting.
I have no clue why it's not formatting the new numbers correctly as this has been working for over a month without a problem. Nothing has changed on the spreadsheet.
Google-Sheetissue, but you haven't provided any information about how the data is formatted in Integromat - have you raised this question with Integromat help, and what was their response?