Skip to main content
Web Applications

Return to Question

Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
edited title
Source Link
user0
user0
  • 27.1k
  • 10
  • 53
  • 78

Selest latest Select last entry from spreedsheet

So I have a google formGoogle Form dumping data into spreadsheet tab form responses 1.

enter image description here

I have created another tab labeled summary. I need to have the summary tab only show the latest entry for a given pilot and be sorted by the main column. My progress thus far is

=QUERY('Form Responses 1'!A2:J,
 "SELECT max(A), B, C, D, E, F, G, H, I, J group by B, C, D, E, F, G, H, I, J")

Unfortunately, this doesn't show only the latest time stamp and for some reason, the query has a weird effect of showing max in the formula cell with a spare row.

enter image description here

Any help would be appreciated.

Selest latest entry from spreedsheet

So I have a google form dumping data into spreadsheet tab form responses 1.

enter image description here

I have created another tab labeled summary. I need to have the summary tab only show the latest entry for a given pilot and be sorted by the main column. My progress thus far is

=QUERY('Form Responses 1'!A2:J,
 "SELECT max(A), B, C, D, E, F, G, H, I, J group by B, C, D, E, F, G, H, I, J")

Unfortunately, this doesn't show only the latest time stamp and for some reason, the query has a weird effect of showing max in the formula cell with a spare row.

enter image description here

Any help would be appreciated.

Select last entry from spreedsheet

So I have a Google Form dumping data into spreadsheet tab form responses 1.

enter image description here

I have created another tab labeled summary. I need to have the summary tab only show the latest entry for a given pilot and be sorted by the main column. My progress thus far is

=QUERY('Form Responses 1'!A2:J,
 "SELECT max(A), B, C, D, E, F, G, H, I, J group by B, C, D, E, F, G, H, I, J")

Unfortunately, this doesn't show only the latest time stamp and for some reason, the query has a weird effect of showing max in the formula cell with a spare row.

enter image description here

Any help would be appreciated.

added 21 characters in body; edited tags
Source Link
user0
user0
  • 27.1k
  • 10
  • 53
  • 78

Google Sheets Query - SELECT Selest latest entry from form spreedsheet

So I have a google form dumping data into spreadsheet tab form responses 1.

enter image description here

I have created another tab labeled summary. I need to have the summary tab only show the latest entry for a given pilot and be sorted by the main column. My progress thus far is =QUERY('Form Responses 1'!A2:J,"SELECT max(A), B, C, D, E, F, G, H, I, J group by B, C, D, E, F, G, H, I, J").

=QUERY('Form Responses 1'!A2:J,
 "SELECT max(A), B, C, D, E, F, G, H, I, J group by B, C, D, E, F, G, H, I, J")

Unfortunately, this doesn't show only the latest time stamp and for some reason, the query has a weird effect of showing max in the formula cell with a spare row.

enter image description here

Any help would be appreciated.

Google Sheets Query - SELECT latest entry from form spreedsheet

So I have a google form dumping data into spreadsheet tab form responses 1.

enter image description here

I have created another tab labeled summary. I need to have the summary tab only show the latest entry for a given pilot and be sorted by the main column. My progress thus far is =QUERY('Form Responses 1'!A2:J,"SELECT max(A), B, C, D, E, F, G, H, I, J group by B, C, D, E, F, G, H, I, J"). Unfortunately, this doesn't show only the latest time stamp and for some reason the query has a weird effect of showing max in the formula cell with a spare row.

enter image description here

Any help would appreciated.

Selest latest entry from spreedsheet

So I have a google form dumping data into spreadsheet tab form responses 1.

enter image description here

I have created another tab labeled summary. I need to have the summary tab only show the latest entry for a given pilot and be sorted by the main column. My progress thus far is

=QUERY('Form Responses 1'!A2:J,
 "SELECT max(A), B, C, D, E, F, G, H, I, J group by B, C, D, E, F, G, H, I, J")

Unfortunately, this doesn't show only the latest time stamp and for some reason, the query has a weird effect of showing max in the formula cell with a spare row.

enter image description here

Any help would be appreciated.

Source Link
Dustin Taylor
Dustin Taylor
  • 21
  • 1
  • 2

Google Sheets Query - SELECT latest entry from form spreedsheet

So I have a google form dumping data into spreadsheet tab form responses 1.

enter image description here

I have created another tab labeled summary. I need to have the summary tab only show the latest entry for a given pilot and be sorted by the main column. My progress thus far is =QUERY('Form Responses 1'!A2:J,"SELECT max(A), B, C, D, E, F, G, H, I, J group by B, C, D, E, F, G, H, I, J"). Unfortunately, this doesn't show only the latest time stamp and for some reason the query has a weird effect of showing max in the formula cell with a spare row.

enter image description here

Any help would appreciated.