I need help auto-incrementing a column in google sheets based on data in another column

by Vaddex   Last Updated August 13, 2019 15:03 PM

I'm working on a spreadsheet linked to a google form and I need to generate an ID for specific response. The form has 2 types of entries: New Entry and Update Entry. I need to assign an ID to the New Entries only that is simply the previous New Entry plus 1, ignoring the Update Entries. So in the ID column there's New Entries with ID's 100, 101, 102 and then an Update Entry with an ID of 55. I need the formula to take the 102 ID and increment it by one, but only if the new response is a New Entry. I'm trying to use an array formula, so it'll react automatically to new responses in the form. But I don't know how to get it to self reference based on these conditions.

This is the base of what I'm trying to use
=ARRAYFORMULA({"ID Test";if((D2:D)="New Entry",(F2:F)+1,"")})

Tags : google-sheets


Related Questions


Updated March 03, 2018 02:03 AM

Updated September 19, 2018 13:03 PM

Updated June 10, 2019 17:03 PM

Updated July 26, 2018 21:03 PM

Updated November 29, 2018 16:03 PM