( by gahvin )
I'm trying to build a spreadsheet that automatically updates certain cells based on form responses that come in another sheet...
Now to get the updated status and comments from the forms, you can get the last row (based on the time in Column A), and then fetch Column B and Column C from it.
Here is the screenshot of Sheet1:
I have the following formula in Cell B2:
=query('Form Responses 1'!A:D;"select C,D where B = '"&A2&"' order by A desc limit 1";0)
I have the following formula in Cell B3:
=query('Form Responses 1'!A:D;"select C,D where B = '"&A3&"' order by A desc limit 1";0)
and so on...
I hope the above solution will help you, and if you need more help then please do comment below on this blog itself, I will try to help you out.