Spreadsheets developer

[FatTaco]

Looking for a developer who can work with google spreadsheets:

We need a google script that creates a new menu item with a button (labeled something like "Update IDs"). When pressed, the button should trigger a google script that does the following:

- Looks at two Sheets inside of a spreadsheet. Perform the following on both Sheets
- For every non-blank cell in a specific column, do the following:
- Check the row corresponding to this cell in a different column (eg if we have a non-blank cell at A15, check N15)
- If that cell is empty, create a new ID number that is 1 higher than the current highest ID number (eg the highest ID number is currently 21, this one should be 22) and fill that ID in the cell

If you're interested in providing this service, send me a message on here with a quote

 

[Androz2091]

Hello. I'm an experienced Javascript developer (https://github.com/Androz2091) but I've never worked with Google Apps Script. I'm interested in developing the script for a very low price (something like $4-5), because I'd like to learn how the API works. You can contact me on Discord (Androz#2091).

 

[kev626]

You don’t even need a script for this. It’s called VLookup.