in Uncategorized

Google Spreadsheets – Auto-Assign Row ID

I was recently working on a simple Google Spreadsheet to log functional requirements for a WordPress Plugin I’m building. I wanted a simple way to assign feature IDs as I entered new rows. My feature numbering system follows the format {version-major}.{version-minor}.{feature-number}. For example “1.1.001” where 1.1 is the version major + minor number, and 001 is the feature number.

I created the following Google Spreadsheets formula to grab the version number and auto-calculate the feature number for me. My version number is in column “E” so take note of that if you use the code. Just copy and paste the formula in the formula field for any cell in your sheet.