Hello; can be like this = ArrayFormula(IF ( NOT ( ISBLANK ( A2:A ) ) ;TEXT(NOW();"dd/MM/yyyy");))
greetings Gilbert Le vendredi 11 septembre 2020 à 21:10:19 UTC+2, Fanie du Preez a écrit : > 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/google-spreadsheets-api/7d04492f-d636-4d47-955c-83af639eca12n%40googlegroups.com.
