New answers tagged spreadsheet
What you're doing it correct, only the format is wrong. There are two ways to resolve that problem: Select the cell or range and goto the menu and select Format, followed by Number. In the date section you can choose the appropriate date format. Use the following formula: =DATEVALUE(EDATE(TODAY(),6)) This will convert the integer (41,797) into a date ...
Using Google Spreadsheets, you can use onEdit.
I have one suggestion: on the next empty column on your Form Response: =Query(range; "select * where x <> '' order by x" , 1) Where range is the range of the responses and x is the column that you want to sort. Hide the columns where the answers are automatically inserted.
Top 50 recent answers are included