title: Find MAX value of column automatically in SpreadSheet
body: <p>I'm currently working with a spreadsheet where I have column with ID's. And I want to find MAX value +1 in this column whenever someone add a new row and place it in correct cell. Any ideas how that could be done automatically? The only user interaction should be adding new row. Let me show you a screenshot to clarify what is my question. </p>
  
  <p><a href="https://i.stack.imgur.com/pwqfZ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/pwqfZ.png" alt="Screenshot"></a></p>