Hi all, Hope you are doing good. Here I am again :slight_smile: My attention is to create running number. Eg : GE-2103-1000-Rev.0 User will enter the date and other details and running number will create by his own. From the date, 21 in the beginning refer to the year. 03 after refer to the m…

[image] vijay: Darren’s and Manu’s solution will generate in the same row, but to generate in the next row will require a different solution. My solution provides an auto-incrementing column. So every time a new row is added, the number in that column will auto-increment by 1. Is that not w…

Hi Biha, As I understand, you would like the running number to be generated from the details entered by the user, you can use the template column to create a new value from values in other cells.

But how to take for example the number 21 only for the year 2021 and 03 for the month of march?

To get 21 out of 2021, one way is to use math: Create another column "Split Year"which subtracts 2000 from year column (2021) to get 21, To get 03, you may create another column “Month Number” and use if-then-else to create number out of Month name “March”. For example: If Month = March, then valu…

Good idea! Do you have any idea on how to do running on 1000 . It will be cumulative column : 1000 1001 1002 1003

[image] Auto Numbering Ask for Help Here is how I would do it: [Screen Shot 2020-12-28 at 5.43.18 PM] “Padding” is just a simple ITE… [Screen Shot 2020-12-28 at 5.43.32 PM] So putting all that together, 4 columns required: Rollup to determine the current max order …

Hi, thanks for replying. It same idea with @vijay . Do you know how to make the number cumulative as go down?

Please refer to the solution in the link that I gave you, as that’s exactly what it does.

For the date in yymm format (YEAR (D) -2000) * 100 + MONTH (D) where D is the date or Now

And for 1000 … 1001 Math column 1000 + X where X is your base number

In this case, are you trying to generate the next row value in a column from the previous row value. Meaning, if ID is 1000 in the ID column in row 20, then in row 21, the ID column should have value 1001, right? Darren’s and Manu’s solution will generate in the same row, but to generate in the next…

Take Certain Text In Cell

Ask for Help

Darren_Murphy March 5, 2021, 9:26am 6

Topic		Replies	Views
Auto Numbering Ask for Help	58	7720	April 18, 2025
How do I create an auto-incrementing row number with Glide Tables? Community Resources tutorial	54	10451	April 18, 2025
Dados automatico Ask for Help	1	470	March 9, 2023
How to get a column with a number Ask for Help	1	32	April 1, 2025
Dans glide, enlever les lignes data ou les date sont dépassée Ask for Help	1	12	April 1, 2025

Take Certain Text In Cell

Related topics