Forum Discussion
Solved
Error when sequencing auto number
Hello... Kindly need someone advise on my problem: So i have created some of data that will be updated in daily basis.. I want to put auto fill number so everytime someone added new row the number...
inidurudi Indeed, the SEQUENCE function generates a dynamic array and these are not allowed inside structured tables. Perhaps the example in the attached file does what you need inside a structured table.
Add data in any of the columns (except the one called Number) and the number in the first column will increment automatically.
Thanks for the reply..
"the SEQUENCE function generates a dynamic array and these are not allowed inside structured tables."
Aahh i got it so i would go for manual one then..
For your suggestions I have tried it but in my case the number become 300, not 1 and when i dragged it is the same number
i tried to add another row it populate random number not in the sequence number