I'm quite new to make, I'm trying to create a scenario where I can be updating ID numbers on google spreadsheet

Getting Started
2

Welcome to the Make community!

The “A” makes the cell/column not a number, hence you cannot increment it.

The two options are:

  1. Have two cells - One with just the number portion, and the other cell with the “A” prepended to it. You increment the number column.

  2. Get the last row’s value, remove the “A” and convert it into a number, before you increment the number

samliew – request private consultation

Join the unofficial Make Discord server to chat with other makers!

2 Likes