Automatically call a cell from the previous row

[fvideira]

I’m trying to call the previous cell in this spreadsheet so that when I add a new report, the LIST_ID just increases by 1 i.e. a new report would automatically input a LIST_ID of 26, if the previous row has a LIST_ID of 25. How may I go around doing this? Is it a simple LOOKUP formula?