Sequential Number Incrementing for Table Not Working

[FrankieVega]

Hi All,

I'm working on customizing an Excel Forms spreadsheet with MS Forms & SharePoint.
Whenever the form is filled out, the excel spreadsheet automatically updates the form with the data requested. I want to add to this form by adding a column that automates a new incrementing number.

Currently I am using the following formula which I thought would work as the table increments with a new row, but instead i just keep getting new entries that keep duplicating the previous entry.

Line 1-8 I manually updated the sequencing and works as expected.
Lines 9-11 is what happens after I update the form and is automated. As you can see, it is not adding in the next sequential number.

Please Login or Register  to view this content.

Any suggestions on how to resolve this would be greatly appreciated!

[tanasedn]

Hi,
select I2 and drag down it will update Your formula with correct entries

[FrankieVega]

Hi Diana,

You are correct, if I manually update the cell and drag it down it works. However whenever a new entry is added, the formula is not updating.

[Glenn Kennedy]

Try this in I2, copy down and then "update" whatever way you do so.

="DCN"&TEXT(ROW()-1,"0000")&-23

[FrankieVega]

Thanks Glenn, I gave it a try and still no go. I might have to take this up with some SharePoint/Forms forums. Thanks for all the suggestions everyone.

[Glenn Kennedy]

"Still no go" tells me nothing. Do you care to explain and show me in an Excel file?

[FrankieVega]

Sorry for the delayed response Glenn. "Still no go" meant that I attempted your suggested solution and it didn't work for me.
I ended up utilizing SharePoint's features to accomplish what I needed. Thank you for your time though, it is appreciated.

[Glenn Kennedy]

Glad you got sorted, but remember for next time that if it doesn't work... SHOW us how it doesn't work. We can not diagnose the invisible...