Updating Cells in Google Sheets by latest Timestamp input from Google Forms

MY PROBLEM: i would like to make updating cells in google sheets based on the last input from a google form. Do somebody know an solution?

WHAT I TRIED I made a query function that takes the form inputs and added a row next to the data that counts every input(=IF(B2="";"";1)than in the cell below(=IF(B3="";"";A2+1), so each new input has a higher value than the one bevor. Then i tried to write a function for a fixed cell that querys the inputs of the list in search for the highest value, but i can´t find a formula that worked.

Has anybody a solution to this ? I would be very happy :)

Example:

Exampe Data

https://stackoverflow.com/questions/66727917/updating-cells-in-google-sheets-by-latest-timestamp-input-from-google-forms March 21, 2021 at 08:59AM