Hi, I wonder who would be able to assist, I am using the formula = ArrayFormula(IF(NOT(ISBLANK(A3:A)),now(), )) to return the current date into a cell automatically when a form response reach the spreadsheet, but it gives me a number in return, I understand that the number represents a date and that you need to set the format of the column to change to the date format, which I did, but as soon as a new submission enters the database it will return in that cell a number again.
-- You received this message because you are subscribed to the Google Groups "Google Spreadsheets API" group. To unsubscribe from this group and stop receiving emails from it, send an email to google-spreadsheets-api+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/google-spreadsheets-api/4c8b2652-ddc3-4009-b755-83363e600624n%40googlegroups.com.
