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?
User | Count |
---|---|
35 | |
11 | |
3 | |
3 | |
2 |